topic Re: how to convert number to percent in SAS Programming

how to convert number to percent

thanikondharish — Mon, 09 Dec 2019 13:30:31 GMT

data ex ;

number=102 ;

format number percent7.2 ;

run;

value should be come like 102.00% .

I have tried above program it is not working.

Re: how to convert number to percent

Kurt_Bremser — Mon, 09 Dec 2019 13:35:10 GMT

Percent values are kept in SAS as relational values, so 102% is stored as 1.02 and displayed as 102.00% by the percent format.

Re: how to convert number to percent

tomrvincent — Mon, 09 Dec 2019 13:39:01 GMT

data ex;
format number percent9.2;
number=1.02;
run;

Re: how to convert number to percent

data_null__ — Mon, 09 Dec 2019 15:44:13 GMT

The PERCENT and PERCENTN format multiply by 100 so the value to be displayed should be a proportion.

35         data _null_;
36            do number=102,-102,1.02,-1.02;
37               put number=percentn12.2;
38               end;
39            run;

number=10200.00%
number=-10200.00%
number=102.00%
number=-102.00%

Re: how to convert number to percent

Ksharp — Tue, 10 Dec 2019 12:57:42 GMT

proc format;
picture fmt
low-high='000.99%';
run;

data ex ;
number=102 ;
format number fmt. ;
run;

Re: how to convert number to percent

ed_sas_member — Tue, 10 Dec 2019 12:39:20 GMT

You can also add the round() function to avoid truncation

proc format;
picture fmt
low-high='999.99%';
run;

data ex ;
number=102 ;
number2 = round(number,.01);
format number2 fmt.;
run;

Re: how to convert number to percent

Ksharp — Tue, 10 Dec 2019 12:56:11 GMT

proc format has such kind of option ROUND .

proc format;
picture fmt(round)
low-high='999.99%';
run;

Re: how to convert number to percent

Tom — Tue, 10 Dec 2019 15:23:18 GMT

To convert 102 into 102% you just need to divide it by 100.