percent format

[sanjay1]

Hi SAS Experts,

Am tryng to get the percentage, but it is rounding up to the nearesr whole value i dont want to get the whole vale. Below is my code and data.

data a;
input cost overall;
datalines;
10000 260000
20400 560970
;
run;

data a1;
set a;
format pct percent10.;
pct=cost/overall;
run;

desired result.

10000 260000 3.8

20400 560970 3.6

Thanks & regards,

Sanjay

[Kurt_Bremser · Accepted solution]

Add decimals to the format:

data a1;
set a;
format pct percent10.1;
pct=cost/overall;
run;

[Ksharp]

  If you don't  want get rounded, try PROC FORMAT.

data a;
input cost overall;
datalines;
10000 260000
20400 560970
;
run;

proc format;
picture fmt
 low-high='00.9%' (multi=1000);
run;
data a1;
set a;
format pct fmt.;
pct=cost/overall;
run;