How to output list(.lst) file into sas dataset

zqkal — Tue, 12 Nov 2013 22:52:12 GMT

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.

Re: How to output list(.lst) file into sas dataset

ballardw — Wed, 13 Nov 2013 16:23:16 GMT

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