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.