topic Re: PROC PRINT grandtotal_label in SAS Procedures

PROC PRINT grandtotal_label

WendyT — Tue, 09 Jun 2020 16:15:47 GMT

Hi SAS folks-

Small issue... was doing a quick proc print, used sum to get a grand total, then couldn't figure out how to label it. Anyone know why grandtotal_label is not working here? (Yes, I could do it in another proc, but got interested.)

Thanks!

Wendy

proc print data=sashelp.shoes label noobs grandtotal_label='Total Sales';
id region ;
sum sales ;
where product='Boot' and region like 'A%' ;
run ;

Re: PROC PRINT grandtotal_label

WendyT — Tue, 09 Jun 2020 16:17:57 GMT

I'm running SAS 9.4M5 on Windows with a remote login, if that makes any difference.

Re: PROC PRINT grandtotal_label

ed_sas_member — Tue, 09 Jun 2020 16:23:30 GMT

Hi @WendyT
the grand total label is actually displayed in the ‘obs’ column.

To see it, you need to remove the NOOBS option as well as the ID statement.

Best,

proc print data=sashelp.shoes label /*noobs*/ grandtotal_label='Total Sales';
*id region ;
sum sales ;
where product='Boot' and region like 'A%' ;
run ;

Re: PROC PRINT grandtotal_label

ChrisHemedinger — Tue, 09 Jun 2020 16:25:05 GMT

I think SUMLABEL and GRANDTOTAL_LABEL kick in only when there is a BY group. That's how those options are documented.

proc print data=sashelp.shoes 
  label noobs sumlabel='Region Sales' 
  grandtotal_label="TOTAL Sales";
by region ;
sum sales ;
where product='Boot' and region like 'A%' ;
run ;

Re: PROC PRINT grandtotal_label

ChrisHemedinger — Tue, 09 Jun 2020 16:27:21 GMT

@ed_sas_member is correct. And...so am I, sort of, with the BY group note. So...take your pick of which approach suits you!

Re: PROC PRINT grandtotal_label

Reeza — Tue, 09 Jun 2020 16:31:45 GMT

Chris, what makes you think that it's only effective on a BY statement. It definitely seems to be valid only with a BY statement but I don't see anything in the documentation that actually explicitly states this is a limit though I'm likely missing it.

Re: PROC PRINT grandtotal_label

ChrisHemedinger — Tue, 09 Jun 2020 16:39:28 GMT

Hi @Reeza - as @ed_sas_member points out, you can use it without BY when the OBS column is displayed. With BY and the SUMLABEL, there's a "Sum" spot allocated so I guess it just renders there. This is probably a function of the ODS template for this in PROC PRINT.

As far as how I read the doc...well, you're right. It doesn't say a BY is needed. I was just thinking like a PROC. "SUMLABEL" is doc'd as needing a BY to display group totals, and a "grand total" is a total of totals...so I just assumed a BY was needed for that too. But I guess not, though it seems to help in some cases 😉