BookmarkSubscribeRSS Feed
jnunesnew
Fluorite | Level 6
Comparing 2 libraries (e.g May vs April) to see if customer ID does not longer exists in the following month ...any SAS code to compare
3 REPLIES 3
Kurt_Bremser
Super User

Do you want to compare libraries or datasets? If you want to compare libraries, do you need to compare certain datasets within the libraries, or all datasets with their respective counterparts?

jnunesnew
Fluorite | Level 6
Hi Kurt many thanks for your response.... We have 2 libraries one for April 20 and the other May20 (with a lot of columns of information) .... we have data for customers in April 20 that no longer exists in May 20... we want to have a sas code to join both libraries and get what customers ID not longer exists in the library of May 20 many thanks for your help.
Kurt_Bremser
Super User

Please supply the library names (ideally by posting the relevant LIBNAME statements), and the names of the datasets within those libraries (use PROC DATASETS to list the libraries).

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 3 replies
  • 751 views
  • 0 likes
  • 2 in conversation