proc tabulate question

Q1983 — Mon, 17 Feb 2014 14:11:07 GMT

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

Re: proc tabulate question

Cynthia_sas — Tue, 18 Feb 2014 13:34:18 GMT

Hi:

I already gave a partial answer in the other forum where you posted this question. Short version: BAL needs to be USED in VAR statement and TABLE statement to show up in output.

cynthia

Re: proc tabulate question

Q1983 — Tue, 18 Feb 2014 13:59:54 GMT

Thanks that was a typo to repeat this

topic Re: proc tabulate question in SAS Programming

proc tabulate question

Re: proc tabulate question

Re: proc tabulate question