topic Re: Formatting Percentages in ODS and Base Reporting

Formatting Percentages

BStats — Tue, 08 Dec 2015 22:55:51 GMT

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

Reeza — Tue, 08 Dec 2015 23:08:58 GMT

You need to create a custom picture format:

proc format;
picture mypct low-high='000,009%';
run;

JerryLeBreton — Tue, 08 Dec 2015 23:11:43 GMT

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%

BStats — Tue, 08 Dec 2015 23:16:34 GMT

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

BStats — Tue, 08 Dec 2015 23:17:31 GMT

Thank you so much!