topic Re: Putting "Total" in the output from proc print and a sum statement in ODS and Base Reporting

Putting "Total" in the output from proc print and a sum statement

Roberta324 — Fri, 20 Feb 2015 15:32:37 GMT

I have the following code:

proc print label noobs data=surv1;

var responsec count1 pct1;

sum count1 pct1;

label responsec='Response'

count1='N'

pct1='Pct';

run;

The output looks like this:

Response N Pct

	68	100%
1-Strongly disagree	11	16%
2-Disagree	8	12%
3-Neither agree nor disagree	30	44%
4-Agree	10	15%
5-Strongly agree	9	13%

Is there a way to add the word "Total" in the last line under "Response"?

Re: Putting "Total" in the output from proc print and a sum statement

Cynthia_sas — Fri, 20 Feb 2015 17:44:42 GMT

Hi:

Look in the PROC PRINT documentation. There is a SUMLABEL= option and a GRANDTOTAL_LABEL= option that can be used. It depends on whether you have BY group processing in the PROC PRINT step or not. Typically, SUMLABEL would be for subgroups and GRANDTOTAL_LABEL would be for the bottom of the report. And if you're not using BY group processing, then you might want to switch to PROC REPORT in order to put some text on the final summary line on the report.

cynthia

Re: Putting "Total" in the output from proc print and a sum statement

tanner_lund — Fri, 01 Mar 2019 15:39:12 GMT

Hello Cynthia!

So am I understanding correctly that using proc print, you aren't able to label any sum unless you use a by variable? Thanks!

Re: Putting "Total" in the output from proc print and a sum statement

Cynthia_sas — Fri, 01 Mar 2019 22:22:40 GMT

Hi:

Yes, SUMLABEL is designed for BY groups. But do not despair. PROC REPORT can come to the rescue:

Hope this helps,

Cynthia

ps forgot to snip title statement -- title statement for code was:

title 'Detail Report';

Re: Putting "Total" in the output from proc print and a sum statement

tanner_lund — Mon, 04 Mar 2019 13:43:09 GMT

Thank you so much!!

Re: Putting "Total" in the output from proc print and a sum statement

AEBatUSB — Wed, 26 Apr 2023 18:23:26 GMT

Is there a way to have "Total" print, when the first column is a number or date? The code below doesn't produce total in the summary line. Nothing appears where I would expect the word Total to appear. This same code works though when the first column is a character. Also, I have other examples where the variable is only one or three characters and the word Total gets truncated to 'Tot' or 'T' in those cases. I've tried to format the variable to be six characters hoping it would trick SAS into thinking that the field should be that width, but as you know, there's no tricking SAS.

For example,

proc report data=sasuser.plan_date out=sasuser.plan_daily_all;
column ('ExtendPay Plans by Date' start_date accts transactions Orig_loan Orig_Fees avg_loan avg_fee loan_term) ;

define start_date /group 'Enrollment Date' center;
define accts /n 'Number of Accounts' format=comma15. center;
define transactions /sum ' Number of Transactions' format=comma15. center;
define orig_loan/ sum 'Total Plan Balance' format=dollar15.0;
define orig_fees / sum 'Total Monthly Plan Fees' format=dollar15.0;
define avg_loan /computed'Avg. Plan Amount' format=dollar15.0;
define avg_fee / computed 'Avg. Plan Fees' format=dollar15.0;
define loan_term /mean 'Avg. # of Payments per Plan' center;

where start_date >'31MAR2023'd;

compute avg_loan;
avg_loan=orig_loan.sum/plans.n;
endcomp;
compute avg_fee;
avg_fee=orig_fees.sum/plans.n;
endcomp;
rbreak after / summarize style(summary)=[font=("Calibri")fontweight=bold];
compute after;
START_DATE = 'Total';
endcomp;
run;

Thank you!

Re: Putting "Total" in the output from proc print and a sum statement

Cynthia_sas — Wed, 26 Apr 2023 21:21:41 GMT

Hi:

Instead of tacking a PROC REPORT question onto a 2015 posting about PROC PRINT, it would be better to start a new post, and if you need to, refer to this older post.

You should be seeing a note in your log with your attempt to assign a text string to a numeric variable. I used a subset of SASHELP.CLASS since I did not have your SASUSER data. Here's the default behavior:

However, there are 2 possible methods to do what you want with PROC REPORT, as shown below:

And, yes, summarizing HEIGHT and WEIGHT is sort of silly, but there just needed to be a summary line on the report.

Cynthia

Re: Putting "Total" in the output from proc print and a sum statement

AEBatUSB — Thu, 27 Apr 2023 13:39:01 GMT

Thank you, @Cynthia_sas. The first option worked.

Re: Putting "Total" in the output from proc print and a sum statement

AhmedAl_Attar — Thu, 27 Apr 2023 14:34:48 GMT

@AEBatUSB
You'll need to mark/accept the post that worked as a solution

Re: Putting "Total" in the output from proc print and a sum statement

AEBatUSB — Thu, 27 Apr 2023 21:33:27 GMT

HI AhmedAl_Attar,
I don’t see a place for me to do that.

Re: Putting "Total" in the output from proc print and a sum statement

AhmedAl_Attar — Fri, 28 Apr 2023 12:52:28 GMT

Hi @AEBatUSB

Honestly I forgot where you should see that option!

I cannot remember the last time I did that "marking a post as a solution".

Keep in mind, The person who originated the post, would be the only one who can mark a post as a solution.

Re: Putting "Total" in the output from proc print and a sum statement

AhmedAl_Attar — Fri, 28 Apr 2023 13:00:51 GMT

I found it!
Go here https://communities.sas.com/t5/help/faqpage/title/solution_howdoi
and look for "How do I mark a message as a solution?" within/under "Accepted Solutions"

Re: Putting "Total" in the output from proc print and a sum statement

AEBatUSB — Fri, 28 Apr 2023 21:19:40 GMT

It's not an option on my post, probably since I replied to an old post instead of creating a new one. No worries, it says in my notes that it worked. Both options worked. I ended up having to change it to the second solution because in SAS EG, when I selected Excel as the output for some reason it dropped the word total on the output - I could see it on the HTML output but not on the export. So, I tried the second option Cynthia provided and now the total appears on my output.