The SAS Output Delivery System and reporting techniques

Formatting Percentages

Accepted Solution Solved
Reply
Contributor
Posts: 24
Accepted Solution

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: 85

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%

 

 

 

 

View solution in original post


All Replies
Grand Advisor
Posts: 16,378

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: 85

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

Re: Formatting Percentages

Thank you so much!

Post a Question
Discussion Stats
  • 4 replies
  • 474 views
  • 0 likes
  • 3 in conversation