topic SAS Macro to Compare two datasets in SAS Programming

SAS Macro to Compare two datasets

juanvenegas — Fri, 16 Nov 2018 15:20:22 GMT

Hi, im new to sas macros. how would I go about creating a macro to do the following:

# Does the comparison table have all columns present in the base dataset?
# Does the comparison table have any columns not present in the base dataset?
# Are corresponding columns between tables of the same data type?
# Are corresponding character columns of the same length?
# Do the tables have the same number of records?

any help is appreciated!

Re: SAS Macro to Compare two datasets

Astounding — Fri, 16 Nov 2018 15:25:40 GMT

Without question, here is the right way to get started.

Cut out the macros.

Write a program that does all of this for two data sets, hard-coding the data set names.

Once you have working code, you can begin to think about how to change that to a macro.

Re: SAS Macro to Compare two datasets

RW9 — Fri, 16 Nov 2018 15:31:10 GMT

Tip 1, use Base SAS.

Tip 2, use the appropriate procedure:

http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n0c1y14wyd3u7yn1dmfcpaejllsn.htm

Proc compare is specifically designed to do these comparisons.

Re: SAS Macro to Compare two datasets

Reeza — Fri, 16 Nov 2018 15:54:34 GMT

PROC COMPARE will output all of those statistics for you. And most you can capture easily into data sets.