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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.