vjust and verticalalign don't seem to be working with tagsets.excelxp. Any suggestions? Thank you. ods tagsets.excelxp file="C:\summary_&date1..xls" style=journal options(frozen_headers='1' autofit_height='yes' zoom='90' absolute_column_width='12,8,8,8,8' sheet_interval='none' sheet_name='Claims by Month') ; proc report data=claims_tots nowd contents="Claims" out=test style(header)=[verticalalign=m font_weight=bold background=cxA3D57D font_size=11pt font_face='Arial Unicode MS'] split='00'x style(column)={verticalalign=m font_size=11pt font_face='Arial Unicode MS'}; options missing='0'; column mdoi mdoic ydoi, (z_tot osha_incident); define mdoi /group order=data noprint; define mdoic /computed 'Month' width=10 style(column)={just=l}; define ydoi /across '' width=5 style=[font_size=13pt FONT_WEIGHT=BOLD just=c] format=yearf. order=data; define z_tot /analysis 'All Claims' style(column)={verticalalign=m background=cxE8E8E8 just=c}; define osha_incident /analysis 'Incident Only' style(column)={just=c}; rbreak after /summarize; compute mdoic /CHAR length=10; if mdoi ^= . then mdoic = put(mdoi,mof.); else mdoic = ' '; if _break_='_RBREAK_' then mdoic = 'Total'; if mdoic in ('Total') then call define(_row_,"style","style=[background=cx8DB4E2 font_size=12pt font_weight=bold]"); if mdoi in ("&currmonth.") then call define(_row_,"style","style=[background=cxE4CD94]"); endcomp; run;
... View more
