02-08-2013 08:59 AM
I'm running a basic Proc compare:
proc compare base=basefile compare=comparefile;
The results show discrepancies in 28 fields, and SAS goes on give short samples of the differences that exist between each file's fields (Value Comparison Results for Variables). However the results are incomplete, only about 14 fields are shown. Is this a bug? I'd like to see the complete list.
02-08-2013 09:10 AM
This procedure is used to give the full description to observation wise.
By default it gives the details of unrelated values.
seems 14 fields are only have unrelated values !!!
If you want to compare exact variables b/n two data sets..
Proc compare base=one compare=two nosummary;
Title 'Comparing Variables with Different Names';
02-08-2013 09:54 AM
I'm not quite sure what unrelated values means, can you point to SAS literature that defines "unrelated values"?
All fields, in terms of format, etc. should be identical.
02-08-2013 10:51 AM
Try adding PRINTALL to the proc call to get all differences.
It is also a good idea to make sure the data sets are both sorted by the ID variable if you haven't already done that.