topic Re: where statement when a variable equals another variable in different dataset in SAS Procedures

where statement when a variable equals another variable in different dataset

m1986MM — Sun, 21 Jun 2015 04:49:53 GMT

Hello everyone,

I have two datasets, named Original and New. I want to create a subset of Original in which the values of the variable XXX are equal to variable YYY in dataset New.

I think it should be similar to where command but I don't know how to create such subset.

I appreciate your suggestions in advance.

Re: where statement when a variable equals another variable in different dataset

Reeza — Sun, 21 Jun 2015 05:58:54 GMT

You end up needing a subquery:

WHERE VAR IN (SELECT VAR from TABLE2);

proc sql;

create table a as

select *

from table b

where id in (Select id from table c);

quit;

Re: where statement when a variable equals another variable in different dataset

naveen20jan — Mon, 22 Jun 2015 13:39:46 GMT

Hi ,

You can use the merge also for the desired result .

data want.

merge a (in = a )

b (in = b) ;

by id ;

if a and b ;

if xxx = yyy ;

run;

thanks

Re: where statement when a variable equals another variable in different dataset

m1986MM — Mon, 22 Jun 2015 15:35:29 GMT

thanks