topic Output diffrent rows values in proc comapre in SAS Programming

Output diffrent rows values in proc comapre

Matt3 — Tue, 05 Sep 2017 07:04:41 GMT

Hello, could anyone please tell me how to output in proc compare diffrence rows from compare dataset.

when I use

proc compare base=temp compare=temp2 out=diff outnoeq;
run;

I receive xxxx values where diffrence exists.

Thank you.

RW9 — Tue, 05 Sep 2017 08:14:58 GMT

Yes, that is default behaviour. The simplest method to get differences is:

proc sql;
  create table WANT as
  select *
  from   TEMP
  except
  select *
  from   TEMP2;
quit;

And you can do the reverese (i.e. temp/temp2 swapped) to get the other way.