topic proc sql, output % to 2 decimal places in SAS Procedures

proc sql, output % to 2 decimal places

SASs33ker — Fri, 16 Mar 2012 17:30:24 GMT

Hi,

I have the following code segment:

how shall I make the % output to display up to 2 decimal places?

Thanks

Reeza — Fri, 16 Mar 2012 17:36:05 GMT

Apply a format to the variable.

proc sql;

create table Q1Only as

select mgmtProgram,

sum(GAFPDGT5='Yes') as Numerator,

count(*) as denominator,

round(calculated numerator/calculated denominator,0.00001) as result format percent8.2

from sasuser.q1_only

group by mgmtProgram;

quit;

SASs33ker — Fri, 16 Mar 2012 19:44:16 GMT

thank you