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!
... View more
