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.
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;
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;
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
thanks
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: