Output diffrent rows values in proc comapre

[Matt3]

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 · Accepted solution]

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.