Help using Base SAS procedures

Proc Compare results come up incomplete

Reply
Contributor
Posts: 27

Proc Compare results come up incomplete

I'm running a basic Proc compare:

proc compare base=basefile compare=comparefile;

id idfield;

run;

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.

Frequent Contributor
Posts: 97

Re: Proc Compare results come up incomplete

PROC COMPARE

   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;

Var id1;

With id2;

Title 'Comparing Variables with Different Names';

Run;

Regards,

ALLU

Contributor
Posts: 27

Re: Proc Compare results come up incomplete

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.

Thanks!!

Super User
Posts: 10,487

Re: Proc Compare results come up incomplete

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.

Ask a Question
Discussion stats
  • 3 replies
  • 153 views
  • 0 likes
  • 3 in conversation