06-15-2016 03:19 PM
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.
06-15-2016 03:38 PM
06-15-2016 06:02 PM
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;
06-16-2016 07:41 AM
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;