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