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
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%
This is turning my 0.24567 into 0%. I need it to be 0.24%
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%
Thank you so much!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.