Hi;
While this might be a bit over-simplified, perhaps it'll get you on your way:
data datain; infile datalines; input age icu cost_sum; datalines; 17 1 10000 65 1 13250 44 2 6200 89 2 23000 ;
proc format; picture perc (round) low-high='09.99%' (multiplier=100); run;
proc tabulate data=datain; var cost_sum; class age icu; table(age icu),(cost_sum) * (n mean std median p25 p75 sum pctsum *f=perc.); run;
I've used the pctsum keyword, one of Cynthia's suggestions, but often programmers have difficulty getting the needed '%' sign to appear. To do this, you'll need to create your own format as I've done above, using a 'picture' statement instead of the usual value statement. Here are some results using the make-believe dataset above:
... View more