Help using Base SAS procedures

Proc Compare Question

Reply
Regular Contributor
Posts: 173

Proc Compare Question

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
Contributor sss
Contributor
Posts: 65

Re: Proc Compare Question

Hi kevin,

There are certain ways are thr . can you come up with sample data ..
Super User
Posts: 10,466

Re: Proc Compare Question

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.
Ask a Question
Discussion stats
  • 2 replies
  • 122 views
  • 0 likes
  • 3 in conversation