topic Compare two dataset with some specific columns? in SAS Programming

Compare two dataset with some specific columns?

ybz12003 — Mon, 25 Apr 2022 13:23:48 GMT

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.

Re: Compare two dataset with some specific columns?

PaigeMiller — Mon, 25 Apr 2022 13:33:25 GMT

PROC COMPARE will do this.

Re: Compare two dataset with some specific columns?

maguiremq — Mon, 25 Apr 2022 16:33:34 GMT

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.