Calcite | Level 5

## 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

1 ACCEPTED SOLUTION

Accepted Solutions
Pyrite | Level 9

## 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%

4 REPLIES 4
Super User

## Re: Formatting Percentages

You need to create a custom picture format:

proc format;
picture mypct low-high='000,009%';
run;
Calcite | Level 5

## Re: Formatting Percentages

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

Pyrite | Level 9

## 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%

Calcite | Level 5

## Re: Formatting Percentages

Thank you so much!

Discussion stats
• 4 replies
• 1469 views
• 0 likes
• 3 in conversation