Values Comparison Summary
Number of Variables Compared with All Observations Equal: 0.
Number of Variables Compared with Some Observations Unequal: 1.
Total Number of Values which Compare Unequal: 389124.
All Variables Compared have Unequal Values
Variable Type Len Label Ndif MaxDif
Receipt CHAR 13 Recipt Number389124
When we use proc compare ,then we get a report in results tab,so under variables with unequal values we have a summary of variables(I have also highlighted in bold).
From that highlighted summary i want to create a data set which with variable and ndif column only.
Thanks you.
Could you please re-format your text so we don't have to scroll right and left to read it? Thanks!
Use something like this:
proc compare base=emp95_byidnum compare=emp96_byidnum
out=result outnoequal outbase outcomp outdif
noprint;
id idnum;
run;
Koen
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.