Compare two datasets

[vnreddy]

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) 

[Reeza · Accepted solution]

Look into PROC COMPARE.