topic Re: compare two dataset to get missing rows in SAS Procedures

compare two dataset to get missing rows

Nasser_DRMCP — Wed, 20 Feb 2019 10:09:28 GMT

Hello,

I have2 datasets with the same strcuture.

the first holds 945057 rows and the second holds 944820 rows.

I would like to get in an output dataset only rows that are missing in the second dataset.

thanks in avdance for your help

regards

Nasser

Re: compare two dataset to get missing rows

RW9 — Wed, 20 Feb 2019 10:16:54 GMT

Something like (not tested as nothing to test on):

data want;
  set have 1 (in=a) have2 (in=b);
  /* Note I do not know what variables are in each so I cannot put anything in the next row */
  by ...;
  if a and not b;
run;

You could also use except in SQL, proc compare with dataset output. Again, without test data in the form of a datastep I can't be anymore specific.