I am trying center my spanned header and I am having difficulties. Any assistance would be great. Please see part of my code below. ods _all_ close; ods tagsets.excelxp file= "/servloc/myfolder/shoes.xls" style=seaside options ( autofit_height = 'yes' row_repeat = '6' Wraptext = 'no' frozen_headers = '6' frozen_rowheaders='6' EMBEDDED_TITLES= 'yes' Orientation = 'landscape' sheet_interval = 'bygroup' suppress_bylines = 'yes' sheet_label = ' ' ); PROC report data=shoes nowd style(header)={just=center}; Title1 j=left font='Cambria' height=12pt bold "Approval Report"; Title2 j=left font='Cambria' height=12pt bold "November 2009 - October 2010" Title3 j=left font='Cambria' height=12pt bold "Designer Name: #byval(brand)"; by brand; ('12 MONTHS TOTAL' approved_0 denied_0 total_0 approval_rate_0) ("&month1" approved_1 denied_1 total_1 approval_rate_1) ("&month2" approved_2 denied_2 total_2 approval_rate_2) ("&month3" approved_3 denied_3 total_3 approval_rate_3) ("&month4" approved_4 denied_4 total_4 approval_rate_4) ("&month5" approved_5 denied_5 total_5 approval_rate_5) ("&month6" approved_6 denied_6 total_6 approval_rate_6) ("&month7" approved_7 denied_7 total_7 approval_rate_7) ("&month8" approved_8 denied_8 total_8 approval_rate_8) ("&month9" approved_9 denied_9 total_9 approval_rate_9) ("&month10" approved_10 denied_10 total_10 approval_rate_10) ("&month11" approved_11 denied_11 total_11 approval_rate_11) ("&month12" approved_12 denied_12 total_12 approval_rate_12); define RANK/computed style(column)={cellwidth=0.4in tagattr='format:#,##0'}; define brand/'BRAND NAME'; define approved_0 - approved_12/ style(column)={cellwidth=0.7in tagattr='format:#,##0'}; define denied_0 - denied_12 / style(column)={cellwidth=0.5in tagattr='format:#,##0'}; define total_0- total_12/ style(column)={cellwidth=0.5in tagattr='format:#,##0'}; define approval_rate_0 - approval_rate_12/ style(column)={cellwidth=0.6in just=right}; compute RANK; rn+ 1; Rank = rn; endcomp; run; ods _all_ close; This is what i get ... it left justifies the header instead of centering it. what am i doing wrong? Thanks. 12 MONTHS TOTAL OCTOBER 2010 SEPTEMBER 2010 AUGUST 2010 RANK BRAND NAME APPROVED DENIED TOTAL % APPRV APPROVED DENIED TOTAL % APRRV APPROVED DENIED TOTAL % APRRV APPROVED DENIED TOTAL % APPRV
... View more