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.
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 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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: