topic Re: Proc Print Question in ODS and Base Reporting

Proc Print Question

KevinC_ — Fri, 09 May 2008 21:26:05 GMT

I am using Proc Print SUM to print the total. Can I use LABEL on the sum?
In the example below, I would like to change "ALLOCNBR" to "Fund Total". How can I do this in proc print?

Thanks for any input!!
KevinC.

PAYMENT
YEAR COUNT TOTAL DUE SPECHNDL

2008 1 $25,000.00 MYP
2009 2 $35,000.00 MYP
2010 2 $45,000.00 MYP
2011 1 $20,000.00 MYP
-------- ---------------
ALLOCNBR $125,000.00

Re: Proc Print Question

Cynthia_sas — Fri, 09 May 2008 22:11:06 GMT

Hi:
Starting in SAS 9.2 you can use the SUMLABEL option to display the BY variable label on the summary line:
http://support.sas.com/documentation/cdl/en/proc/59565/HTML/default/a000064114.htm

However, PROC REPORT has always had the capabililty to do this -- 2 examples are below -- one with BY groups and one without:
[pre]
proc report data=sashelp.shoes nowd;
where region in ('Asia', 'Canada') and
product='Slipper';
column region subsidiary sales;
define region / order;
break after region / summarize;
compute after region;
Region = 'Fund Total';
endcomp;
run;

proc report data=sashelp.shoes nowd;
where region in ('Asia', 'Canada') and
product='Slipper';
by region;
column region subsidiary sales;
define region / order noprint;
break after region / summarize;
compute after region;
Subsidiary = 'Fund Total';
endcomp;
run;

[/pre]

You may have to do some other small changes if ALLOCNBR or YEAR is numeric. But PROC REPORT may get you what you want without waiting for 9.2 to be installed.

cynthia

Re: Proc Print Question

KevinC_ — Mon, 12 May 2008 20:47:46 GMT

Thank you so much Cynthia !!!