proc sql;
create table action as
select distinct Region,count(ln_no) as ln, sum(balance) as bal
from main;
where region = 'West';
quit;
Sample output is
Region ln bal
West 2500 2300000
I created a proc tabulate with the intention of capturing both the count of the ln_no and the sum of the balance
Proc tabulate data=action order= data format=10. S=[cellwidth=150];
Class Region;
Var ln;
Table Region=' ' all={label='Grand Total' S=[background = lightblue cellwidth=160]} *[STYLE=[Font_Weight=BOLD]],
Region='Status '*ln=' '*sum=' '
all={label='Grand Total' S=[background = lightblue]} *[STYLE=[Font_Weight=BOLD]] *ln=' '*sum=' ' / box='Investor Group';
TITLE 'Loan Status';
My results give me a summary of the count of the loan however I am not getting the total or sum of the balance. Essentially I am getting the 2500 but not the 2300000. In addition how would I format the bal so it reads as a dollar format such as $2,300,000.00
