PROC DATA_COMPARE .. Data set comparison

srinidelite — Wed, 07 Jun 2017 11:12:57 GMT

Hi All ,

I would like create a customised report by comparing two data set ..

Example consider the below two data sets SOURCE and TARGET .. All i wanted to achieve is produce a report on mismatch value by using primary key

REPORT LIKE BELOW

------------------------------

I tried using PROC_COMPARE however i don't know how to customise .. please can some one help me im very new to SAS programming

Re: PROC DATA_COMPARE .. Data set comparison

Shmuel — Wed, 07 Jun 2017 11:45:22 GMT

Proc compare will not create a report as you want, but have you tried:

proc compare base=source compare=target
             criterion=0.01;
        id primary_key;
run;