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
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.