Date:         Mon, 20 Apr 2009 05:28:25 -0400
Reply-To:     Daniel Santos <dgms@IOL.PT>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Daniel Santos <dgms@IOL.PT>
Subject:      Re: Code help to select records based on condition

Easily done with a simple inner join SQL between the standard dataset and
the current month dataset.

see: http://www2.sas.com/proceedings/forum2007/071-2007.pdf

Greetings from Portugal.

Daniel Santos at www.cgd.pt

On Sun, 19 Apr 2009 20:10:43 -0700, sasbegy <pattukuttani@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         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?