Date:         Tue, 17 Sep 2002 00:28:00 GMT
Reply-To:     Andrew Foster <afoster@NBNET.NB.CA>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Andrew Foster <afoster@NBNET.NB.CA>
Organization: Aliant Internet
Subject:      Re: read dataset values in "IN" statment

I think I figured it out, PLS let me know if this is right or/and if I can
do another way.

proc sql;
select x.enum
from a x, b y
where x.account number = y.account number
                        and
           y.name = andrew
;
quit;

"Andrew Foster" <afoster@nbnet.nb.ca> wrote in message
news:Q4uh9.4345$0i4.604545@ursa-nb00s0.nbnet.nb.ca...
> two datasets 'a' and 'b'
> where a is account numbers
> and b has account numbers and names
>
> I need follwoing:
>
> data x;
> set b;
> if account number IN a then do;
>     if name = andrew then output;
> end;
> run;
>
>
>