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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.