compare two dataset to get missing rows

[Nasser_DRMCP]

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

[RW9 · Accepted solution]

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.