topic proc print format in SAS Programming

proc print format

ss171 — Wed, 02 Dec 2020 15:33:38 GMT

proc print data=sashelp.class
noobs round GTOTAL_LABEL="TOTAL" style(header)={backgroundcolor=cyan color=black fontsize=2 fontweight=bold just=center} 
style(header data)={bordertopwidth=.5 borderbottomwidth=.5
borderleftwidth=.5 borderrightwidth=.5 borderstyle=solid bordercolor=black};
sum height age /STYLE(GRANDTOTAL)={backgroundcolor=cyan color=black fontsize=2};
var name;
var age height ;
run;

I am not getting Total to be wriiten in Output. Can anybody help me with proc print GTOTAL_LABEL options available in proc print .

Re: proc print format

PaigeMiller — Wed, 02 Dec 2020 15:52:44 GMT

Works with a BY statement. Otherwise, without a BY statement in PROC PRINT, no GRANDTOTAL is printed, only a SUM is printed (and you can use SUMLABEL=' ').

Re: proc print format

Reeza — Wed, 02 Dec 2020 16:05:53 GMT

Use the right tool for the right job, AKA it would be easier with REPORT or TABULATE.

Re: proc print format

ss171 — Thu, 03 Dec 2020 10:58:00 GMT

With sumlabel as well I am not getting Total . Is SUMLABEL also works with BY only ?

Re: proc print format

andreas_lds — Thu, 03 Dec 2020 11:07:03 GMT

From the docs:

SUMLABEL='label'

specifies the text to use as a label on the summary line of a BY group. You can include the #BYVAR and #BYVAL variables in 'label'.

Re: proc print format

Reeza — Thu, 03 Dec 2020 18:26:13 GMT

Yes, SUMLABEL only works with a BY statement. You can add a fake BY statement and use just the GRANDTOTAL option instead of subtotals if that will work. Again, wrong tool for what you're trying to do.

topic proc print format in SAS Programming

proc print format

Re: proc print format

Re: proc print format

Re: proc print format

Re: proc print format

SUMLABEL='label'

Re: proc print format