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!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.