Before I get to my question let me explain a few things .
I’m creating a report that will show differences between two SAS datasets. These two SAS datasets have 14 million observations and 390 variables.
I used PROC compare to create the a list file with all the differences between each observations and then output the list file into SAS dataset.
Ods listing close;
Ods ouput CompareSummary=compare_summary;
Proc compare base=first_dataset compare=second_dataset
Maxprint(100,5000) novalues listequalvar;
Id key;
Run;
Ods output close;
Ods listing;
Does anyone knows why SAS takeout the space between len2 and Ndif?
Does anyone know how I could output part of the list file “variables with Unequal Values” into 4 column?
Thanks in advance.
You don't show anything related to len2 or Ndif so can't say anything about spaces.
I think you might be well off to examine the output data set options that proc compare will generate such as :
out=outputsetname outnoequal outdif
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.