topic Proc Compare Question in SAS Procedures

Proc Compare Question

KevinC_ — Mon, 18 Apr 2011 17:22:03 GMT

Hello everyone,

When I campare 2 datasets can I output the different observations only? I dont need to see all of the observations that are equal to each other.
Here is the code I use but it's printing every row..

proc compare base=doc1 comp=doc2d nosummary out=xx outdif;
var impressions;
run;

Thanks for any input!
Kevin

Re: Proc Compare Question

sss — Mon, 18 Apr 2011 18:04:35 GMT

Hi kevin,

There are certain ways are thr . can you come up with sample data ..

Re: Proc Compare Question

ballardw — Mon, 18 Apr 2011 19:34:15 GMT

First make sure that the two sets are sorted the same.

You may also want to set a FUZZ value of something like 0.000001.
I've had lots of cases comparing aggregated data back to an original data set where the differences were in the 1E-13 range and PROC COMPARE will set tell you they are all different. So either FUZZ or round values may help.