BookmarkSubscribeRSS Feed
rakeshvvv
Quartz | Level 8

I have two libraries(A and B) with similar kind of data sets (Datasets name is same in both libraries. EXAMPLE: AE ) and same structure with one common variable of ID in all datasets. I want to write a generalized macro which would compare same datasets name in two libraries(AE in both libraries A and B) and will pull out those ID which are present in A.ae but not in B.ae and vice versa.


Thanks

2 REPLIES 2
jakarman
Barite | Level 11

proc compare?

---->-- ja karman --<-----
Astounding
PROC Star

If you show us how you would compare A.ae to B.ae, there are many posters here who can show you how to turn that into a macro to (1) find a list of all common data sets in the libraries, and (2) compare each pair.  But if you don't know how to make the comparison for a single data set, well, you have to be able to do that before you can consider writing a macro.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

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

Browse our catalog!

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