topic percent format in SAS Programming

percent format

sanjay1 — Thu, 29 Jun 2017 08:25:55 GMT

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

Re: percent format

Kurt_Bremser — Thu, 29 Jun 2017 08:39:38 GMT

Add decimals to the format:

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

Re: percent format

Ksharp — Thu, 29 Jun 2017 12:53:12 GMT

  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;