Solved
Contributor
Posts: 24

Formatting Percentages

Hi,

I am writting constructing a table using proc report. One of the columns being displayed is a list of percentages

PercentUsed

99.267561

0.2447182

0.4967894

76.229856

How can I format this colum so that it appears as what is shown below, within the proc report table.

PercentUsed

99.26%

0.24%

0.49%

76.2%

If I use the format=percent it times eveything by 100. So I get 9926 rather then 99.26

Accepted Solutions
Solution
‎12-08-2015 06:17 PM
Frequent Contributor
Posts: 88

Re: Formatting Percentages

Create a PICTURE format like this:

proc format;

picture pcent low-high='009.99%';

run;

data _null_;

PercentUsed = 99.34567;

x = put(PercentUsed, pcent.);

put x=;

run;

x=99.34%

All Replies
Super User
Posts: 23,357

Re: Formatting Percentages

You need to create a custom picture format:

proc format;
picture mypct low-high='000,009%';
run;
Contributor
Posts: 24

Re: Formatting Percentages

This is turning my 0.24567 into 0%. I need it to be 0.24%

Solution
‎12-08-2015 06:17 PM
Frequent Contributor
Posts: 88

Re: Formatting Percentages

Create a PICTURE format like this:

proc format;

picture pcent low-high='009.99%';

run;

data _null_;

PercentUsed = 99.34567;

x = put(PercentUsed, pcent.);

put x=;

run;

x=99.34%

Contributor
Posts: 24