BookmarkSubscribeRSS Feed
KevinC_
Fluorite | Level 6
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
2 REPLIES 2
sss
Fluorite | Level 6 sss
Fluorite | Level 6
Hi kevin,

There are certain ways are thr . can you come up with sample data ..
ballardw
Super User
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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 634 views
  • 0 likes
  • 3 in conversation