proc compare

[deleted_user]

Is there a way we can persuade the normal output from proc compare to be nicely formatted. I don't mean taking output datasets and laying out their printing, but just from the native running of proc compare.
The procedure produces tables of comparison that look like candidates for the ODS approach.

PeterC

[JuanVte]

Hi PeterC,

I don't know any way to do that but it is true that this procedure output is awful. I have thought several times about to create a macro in order to do this task with a nicer output but it is still in my to do list.

Now, I am quite busy but if you are interested in doing that maybe we could arrange something!

Or perhaps somebody in this forum has already done it? 😉

Best regards,
Juanvte.

[deleted_user]

Juanvte
thank you, but ...

SAS9.2 documentation indicates PROC COMPARE supports ODS. I wouldn't recommend investing your time (or mine) on building this solution with such a short pay-back period.

PeterC

[Sheri]

Thanks for the ODS tip. I got very readable output with the code below:

PROC COMPARE BASE=Testfil.CurrentSCIP COMPARE=Testfil.NewSCIP OUTNOEQUAL
OUT=COMP OUTSTATS=COMPSTAT
BRIEF MAXPRINT=1 NOVALUES OUTNOEQUAL;
VAR SCIP1_d SCIP1_n SCIP2_d SCIP2_n SCIP3_d SCIP3_n n;
BY Patient_ID;
run;

ODS RTF FILE='L:\CoreMeasures\SCIP\Compare.RTF';
PROC PRINT DATA=COMP;
RUN;
ODS RTF CLOSE;