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.
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.