How to print observations not in subset data set

[ajb]

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.

[Cynthia_sas]

Hi:
The SAS procedures for reporting (PRINT, REPORT, TABULATE) only work with one dataset at a time. You could do a MERGE before your PRINT or REPORT step or you could join the 2 datasets with PROC SQL and generate the non-matches in an SQL report. It depends on your comfort level with the idea of MERGING before you run the report/print or whether you are more comfortable with SQL.

cynthia

[jklaverstijn]

Easiliy done in SQL:

proc sql;
    select * from A
      EXCEPT
    select * from B;
quit;

Hope this helps,

- Jan.

[ajb]

Is there a line of code I could use to output the results to a new data set?

I am not at all familiar with sql.

[PGStats]

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;

[jklaverstijn · Accepted solution]

---

@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.