Hi friends, I'm working with survey data. For my Q2 I start with a frequency table that counts and creates a percentage. (Note that it's the real percentage already multiplied by 100.) In my proc report, I want the percentage rounded so I included format=8.1. However, I want my final report to have actual percentage signs. I think I essentially want a double format. What can I do to have my cake and eat it too? I don't think I can use the percent format here. I've tried one of those picture formats (low-high) but it doesn't work because I also want it to round. proc freq data=Lib.Q2Response noprint;
tables Q2 / missing out=Lib.Q2_freq nocol nocum all;
run;
proc report data=Lib.Q2_freq nowd
style(header)=[color = cxCC0000];
columns Q2 Count percent Q2=Avg;
define Q2 / left display "Response" width=45;
define percent / center analysis sum "%" format=8.1 width=10;
define Count/center analysis sum "N" width=10 ;
define Avg/ center analysis mean weight=Count noprint;
rbreak after / summarize
style(summary)=[color = cxCC0000 font_weight=bold just=center];
compute after / style =[just=left color =cxCC0000 fontstyle=italic];
line 'Mean Rating' +145 Avg 8.2;
endcomp;
Compute before _page_ / style =[just=center fontsize=10pt fontweight=bold] ;
line "TITLE OF MY TABLE";
endcomp;
run; (I want my table to say 3.8%, etc.)
... View more
