topic Re: How to print observations not in subset data set in SAS Programming

How to print observations not in subset data set

ajb — Wed, 15 Jun 2016 19:19:05 GMT

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.

Re: How to print observations not in subset data set

Cynthia_sas — Wed, 15 Jun 2016 19:38:55 GMT

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

Re: How to print observations not in subset data set

jklaverstijn — Wed, 15 Jun 2016 19:50:03 GMT

Easiliy done in SQL:

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

Hope this helps,

- Jan.

Re: How to print observations not in subset data set

ajb — Wed, 15 Jun 2016 21:44:19 GMT

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.

Re: How to print observations not in subset data set

PGStats — Wed, 15 Jun 2016 22:02:44 GMT

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;

Re: How to print observations not in subset data set

jklaverstijn — Thu, 16 Jun 2016 11:41:23 GMT

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