Hi,
I have two datasets with same datatypes and same variables names, each dataset has 100+ variables in it. And they are from different sources(SAS libraries).
I got a business problem to identify the variables with different data in it from both the datasets.
e.g. Dataset A with column STREET has values something like below.
8 BATH ROAD
7 CRIB Y SIANEL
RHONDDA HOUSE, PENDINE
Dataset B with column STREET values like below:
BATH ROAD
CRIB Y SIANEL
RHONDDA HOUSE
Here is the difficulty i have: Dataset A is from an old system and Dataset B is from New system.
It's a migration work, data from B has more rows than A. Is there any way i can give few examples scenarios where columns with like data and unlike data(STREET).
Tried proc compare using a ID variable from both A and B, but as i said, B is having more rows.
My requirement is to give variables with different values(STREET) like 5 obs. This is to tell new system(B) values are different from old system(A)
Look into PROC COMPARE.
Look into PROC COMPARE.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.