topic Re: proc compare in ODS and Base Reporting

proc compare

deleted_user — Fri, 28 Mar 2008 13:28:12 GMT

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

Re: proc compare

JuanVte — Mon, 31 Mar 2008 13:11:49 GMT

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.

Re: proc compare

deleted_user — Mon, 31 Mar 2008 13:21:33 GMT

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

Re: proc compare

Sheri — Thu, 10 Apr 2008 18:59:59 GMT

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;