Hello, I am coding to report into an excel as below, where I want all three columns dayA dayB dayC in percent8.2 format, such as 89.28%, but why for some data, I could only get %, but without 89.28; for some, I only get 90%, which has rounded to percent 8.0 automatically. Please help, thanks a lot! Proc report data=sum contents=" " nowd split='\' style(header)={color=black just=center background=lightgrey fontweight=bold } style(column)={color=black just=center background=lightcyan foreground=black }; title1 j=c color=black HEIGHT=14pt BOLD "band31+"; column strat_band dayA dayB dayC; define strat_band/ "Band" style=[fontstyle=Roman fontweight=bold width=2in font_size=2.2 cellwidth=2in just=center foreground=black]; define dayA/ "31+Day " ; define dayB/ "31+A" ; define dayC/ "31+B" ; %macro comp(arg); compute &arg; if strat_band= '190-194' then call define(_col_,'format','percent8.2'); if strat_band= '225-229' then call define(_col_,'format','percent8.2'); if strat_band= '225-229' then call define(_col_,'format','percent8.2'); if strat_band= '230-234' then call define(_col_,'format','percent8.2'); if strat_band= '235-239' then call define(_col_,'format','percent8.2'); if strat_band= '240-244' then call define(_col_,'format','percent8.2'); if strat_band= '245-249' then call define(_col_,'format','percent8.2'); endcomp; %mend common_lines; %comp(dayA ); %comp( dayB ); %comp( dayC); RUN;
... View more