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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: