BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hello,

I am comparing two data sets using proc compare. I am outputing results to display all three recods (base, compare, dif). For some reason, some 'base' and 'compare' records have a matching ID, but there is no Dif record displayed. About half my population is showing a "Dif' record in the out file, but for others is not. Can anyone offer any explanation as why this may be occuring. note: Data is sorted before compare.

proc compare base=in.data_1 compare=in.data_2
outbase outcomp outdif out=out.data_3

id ID;
1 REPLY 1
deleted_user
Not applicable
Try using OUTALL instead of outbase outcomp outdif
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1160 views
  • 0 likes
  • 1 in conversation