Hi all, I'm trying to put a space either at the right or the left of a column in proc report. Below is my code, the current table (dummy results and columns!) and the desired table (dummy columns and results!). I've tryed so many things either in the proc template or in proc report (spacing=, borderleftwidth=, borderspacing=...), either in the define statement or in the style options. * Template for table outputs; proc template; define style tablestyle; class table / frame=box rules=groups; style systemtitle / fontfamily="times" fontsize=2; style systemfooter / fontfamily="times" fontsize=2; end; run; ods listing close; options orientation=portrait center; ods rtf file="mytable.rtf" style=tablestyle; ods rtf text="^S={font=('Times',12pt,bold)}&title4"; proc report data=final missing nowd headline center split="~" style=[protectspecialchars=off font_face="&font" font_size=9 pt posttext="\ql\li&pos &footnote1 \ql\li&pos &footnote2 \ql\li&pos &footnote3"] style(header column)=[protectspecialchars=off font_face="&font" font_size=9 pt ]; column pageno ord v1 last_group_ind v2 gendern1-gendern4; define pageno / order order=data noprint; define ord / order order=data noprint; define v1 / order "Category^{super a}" style(header)=[just=center fontweight=bold borderrightcolor=very light gray] style(column)=[asis=on just=left fontweight=bold cellwidth=1.4in ]; define last_group_ind / order noprint; define v2 / display " " style(header)=[just=left fontweight=bold borderrightcolor=very light gray] style(column)=[asis=on just=left cellwidth=1.4in]; define gendern1 / display "Female" style(header)=[just=center fontweight=bold borderrightcolor=very light gray] style(column)=[just=right cellwidth=0.9in]; define gendern2 / display "Male" style(header)=[just=center fontweight=bold borderrightcolor=very light gray] style(column)=[just=right cellwidth=0.9in]; define gendern3 / display "No gender data" style(header)=[just=center fontweight=bold borderrightcolor=very light gray] style(column)=[just=right cellwidth=0.9in]; define gendern4 / display "Overall Total" style(header)=[just=center fontweight=bold] style(column)=[just=right cellwidth=0.9in borderspacing=]; break after pageno / page; *** This is to get gray lines in the table ***; compute pageno; call define('_c1_','style', 'style=[bordertopcolor=black borderrightcolor=very light gray]'); endcomp; compute ord; call define('_c2_','style', 'style=[bordertopcolor=black borderrightcolor=very light gray]'); endcomp; compute v1; call define('_c3_','style', 'style=[bordertopcolor=very light gray borderrightcolor=very light gray]'); endcomp; compute last_group_ind; call define('_c4_','style', 'style=[bordertopcolor=very light gray borderrightcolor=very light gray]'); if last_group_ind ne "" then hold=last_group_ind; endcomp; compute v2; call define('_c5_','style', 'style=[bordertopcolor=very light gray borderrightcolor=very light gray]'); if hold = v2 then do; call define(_row_,'style','style=[borderbottomwidth=1pt borderbottomcolor=black]'); end; endcomp; compute gendern1; call define('_c6_','style', 'style=[bordertopcolor=very light gray borderrightcolor=very light gray]'); endcomp; compute gendern2; call define('_c7_','style', 'style=[bordertopcolor=very light gray borderrightcolor=very light gray]'); endcomp; compute gendern3; call define('_c8_','style', 'style=[bordertopcolor=very light gray borderrightcolor=very light gray]'); endcomp; compute gendern4; call define('_c9_','style', 'style=[bordertopcolor=very light gray]'); endcomp; run; ods rtf close; ods listing; Thank you!
... View more
