topic Re: Comparing 2 libraries in SAS Enterprise Guide

Comparing 2 libraries

jnunesnew — Sat, 13 Jun 2020 06:14:50 GMT

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

Re: Comparing 2 libraries

Kurt_Bremser — Sat, 13 Jun 2020 06:32:23 GMT

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?

Re: Comparing 2 libraries

jnunesnew — Sat, 13 Jun 2020 13:24:43 GMT

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.

Re: Comparing 2 libraries

Kurt_Bremser — Sat, 13 Jun 2020 13:33:34 GMT

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