Date:         Mon, 20 Apr 2009 09:06:38 -0700
Reply-To:     sasbegy <pattukuttani@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sasbegy <pattukuttani@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Code help to select records based on condition
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi,

Since am a beginner I really cannot make out how to do this piece.
Also the need is to search for the strings in the current month data
set if it matches with the standard data set I should write them to a
new data set.

I need to search for the string in the standard data set and if
matches return them. Any help is appreciated.




> On Sun, 19 Apr 2009 20:10:43 -0700, sasbegy <pattukutt...@GMAIL.COM> wrote:
> >Hi,
>
> >Data set standard
>
> >Market           Products
> >Food&Drug      Toothpaste
> >Food&Drug      shampoo
> >food& drug       talcum powders
> >grocery            frozen foods
> >grocery            vegetables
> >electronics        vcd
> >electronics        tv
>
> >data set current month
>
> >Market             products
> >food&drug         toothpaste
> >food&drug         medicines
> >food&drug         shampoo
> >food & drug        talcum powder
> >grocery              pizzas
> >grocery              frozen foods
> >electronics         Philips tv
>
> >data set needed for current month
> >Market             products
> >food&drug         toothpaste
> >food&drug         shampo
> >food & drug        talcum powder
> >grocery              frozen foods
> >electronics         tv
>
> >I need a code to choose only the markets and products that I have in
> >the standard data set and create a new data set with those values.
>
> >Basically I have a data set where the company has its products in.
> >Each month the market researcher sends the results from general
> >database. I need to choose only for the markets and the products that
> >my company is in and move that to a seperate data set.
>
> >I need a sas code to do this. Is there a way to do this?- Hide quoted text -
>
> - Show quoted text -