The SAS Output Delivery System and reporting techniques

PROC Tabulate - Sum

Reply
N/A
Posts: 0

PROC Tabulate - Sum

I have the following code for proc tabulate:

ods tagsets.ExcelXP style=sasweb2 file='c:\PC_SAS\Balance_Generation_Final.xls'
options( default_column_width='12, 12, 12, 12, 12'
sheet_interval='none' sheet_name='Total Summary' frozen_rowheaders='yes' rules='yes');
proc tabulate data=bal_gen_calc order=data;
where _type_ in (0,29); title;
class campaign_type term rate dte;
classlev Dte;
var tran_amt apr offer_term;
table Campaign_Type,
term *rate *(tran_amt*f=dollar15. apr*f=percent10.2 offer_term)* SUM='',
Dte / box={label=_PAGE_ s=[background=white]};
label tran_amt='Balances';
run;quit;

I would like to see the grand totals at the bottom of the table for tran_amt,apr,offer_term. Any ideas on how to do that? APR is a percentage.
Valued Guide
Posts: 2,177

Re: PROC Tabulate - Sum

Posted in reply to deleted_user
please could you provide a small sample file like the file
data=bal_gen_calc
SAS Super FREQ
Posts: 8,865

Re: PROC Tabulate - Sum

Posted in reply to deleted_user
Hi,
Generally, grand totals in PROC TABULATE come through the use of the ALL universal class variable. So I might expect to see something like this in your TABLE statement:
[pre]
table Campaign_Type,
term *rate *(tran_amt*f=dollar15. apr*f=percent10.2 offer_term)* SUM='' all*(tran_amt*f=dollar15. apr*f=percent10.2 offer_term)* SUM='',
Dte all
/ box={label=_PAGE_ s=[background=white]};

[/pre]

You could even have Campaign_Type ALL, in your TABLE statement, but you said you wanted the grand totals at the bottom of each table, not at the bottom of each page dimension.

cynthia
N/A
Posts: 0

Re: PROC Tabulate - Sum

Posted in reply to deleted_user
That worked! Thank you.

Once I add the totals to the bottom, how do I specify which I want summed verses a just showing a percentage?

For example: The tran_amt needs to be summed, but the APR and offer_term do not(they are percentages). The all step I am using now sums all 3 which leaves me with large % totals.

Any way to not have all 3 sum?
SAS Super FREQ
Posts: 8,865

Re: PROC Tabulate - Sum

Posted in reply to deleted_user
Hi:
Take apr and offer_term out of the all*() parentheses and just leave tran_amt inside the parentheses.

cynthia
Ask a Question
Discussion stats
  • 4 replies
  • 274 views
  • 0 likes
  • 3 in conversation