Sas 9.4
HI,
So I have 2 data set. Data set A has 4000 observations and Data set B has 3000 observations. I know that B is a subset of A but I do not know which observations are in B. How can I have SAS print the 1000 observations that are only in A?
Thanks in advance.
@ajb wrote:
Is there a line of code I could use to output the results to a new data set?
Yes there is: CREATE TABLE AS. Eg.
proc sql;
create table want as
select * from A
EXCEPT
select * from B;
quit;
Regards,
- Jan.
Easiliy done in SQL:
proc sql;
select * from A
EXCEPT
select * from B;
quit;
Hope this helps,
- Jan.
This would work, I think
proc sort data=a; by _all_; run;
proc sort data=b; by _all_; run;
data aMinusb;
merge a b(in=inb);
by _all_;
if not inb;
run;
proc print data=aMinusb; run;
@ajb wrote:
Is there a line of code I could use to output the results to a new data set?
Yes there is: CREATE TABLE AS. Eg.
proc sql;
create table want as
select * from A
EXCEPT
select * from B;
quit;
Regards,
- Jan.
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.