- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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%
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
proc format;
picture mypct low-high='000,009%';
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
This is turning my 0.24567 into 0%. I need it to be 0.24%
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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%
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much!