Desktop productivity for business analysts and programmers

Comparing 3 datasets

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

Comparing 3 datasets

Hello!

 

I'm looking to compare observations with the same id from three datasets. I've been using:

proc compare base=ctavcm compare=ctavtrax out=cmvstraxcomp outstats=cmvstraxcompstat outbase outcomp outnoequal listobs transpose;
	by order;
	var appt rel_rsn order_sts close_rsn;
	format appt mmddyy10.;
run;

To compare two of them. And have follow up code to essentially compare pairings of the datasets. D1 to D2, D2 to D3 and D3 to D1, but am looking for a more efficient way to do this if one exists.

 

Thanks!

 


Accepted Solutions
Solution
‎09-12-2017 10:06 AM
Super User
Posts: 11,343

Re: Comparing 3 datasets

Are you looking for something in specific? It may be that combining the data sets and getting the source name as variable will allow calculations or summaries that at least put all 3 sets in a specific order. This would be more useful if there is a pretty much one-to-one relationship between the sets.

View solution in original post


All Replies
Solution
‎09-12-2017 10:06 AM
Super User
Posts: 11,343

Re: Comparing 3 datasets

Are you looking for something in specific? It may be that combining the data sets and getting the source name as variable will allow calculations or summaries that at least put all 3 sets in a specific order. This would be more useful if there is a pretty much one-to-one relationship between the sets.

Occasional Contributor
Posts: 8

Re: Comparing 3 datasets

It's part of a data profiling effort. I'm trying to get an understanding of the discrepancies between the datasets.

Occasional Contributor
Posts: 8

Re: Comparing 3 datasets

Combining the three datasets was the perfect solution! Once combined I was able to create subsets with uncommon ids as well as perform a comparison between the IDs that existed in all three locations. Thank you!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

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