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).

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 1086 views
  • 0 likes
  • 2 in conversation