Hi folks, I have a manager who wants to see all the differences in a comparison between two datasets in a separate dataset. At the moment I'm using proc compare but the maximum number of differences is 32000, which may not accomodate all the differences. If I use the 'outnoequal' option it only lists the difference as 'X' for character fields or as the difference for numerical fields, this is not what the manager wants as he needs to see the actual values. Any suggestions on how to achieve this? I've about 50 datasets I need to compare. *sample data to check;
data class;
set sashelp.class;
if age=12 then weight=50;
if age=14 then sex="T";
run;
*proc compare test;
proc compare data=class compare=sashelp.class out=check outnoequal;
id name;
run; What I would like to see in the difference dataset is something like this: If I use the outnoequal option I only see this: Any help is great appreciated.
... View more