Compare two dataset with some specific columns?

[ybz12003]

Hello, 

I would like to compare two datasets, A and B. Both of them have around the same 20 columns, some are numeric and some are characteristic.  Please show me how to approach it.

[PaigeMiller]

PROC COMPARE will do this.

[maguiremq · Accepted solution]

proc compare listbase listcompare
base = a compare = b;
id <enter your ID or ID's of choice here>; /* Remove the < and > - those are just placeholders */
var <enter your vars here>; /* Remove the < and > - those are just placeholders */
run;

Documentation: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n0c1y14wyd3u7yn1dmfcpaejllsn.htm

This is the best I can do for you without a reproducible example. If you're unable to get what you need, please post some example data or use this macro to generate data sets from your actual data, ensuring you don't have anything confidential in them.