Compare two datasets

vnreddy — Wed, 27 May 2020 15:31:48 GMT

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)

Re: Compare two datasets

Reeza — Wed, 27 May 2020 16:16:36 GMT

Look into PROC COMPARE.

topic Re: Compare two datasets in SAS Programming

Compare two datasets

Re: Compare two datasets