When using the indent feature (for example: call define ("description" , 'STYLE', 'STYLE=[INDENT=4]') ), the xml file that is created only shows indents of 2, no matter what value is entered. When the proc report is output in HTML, the indents are rendered correctly, such that indent=XXX will indent however much XXX is indicated. When using tagsets.excelxp however, no matter what value is indicated in indent=XXX, the indent is only 2 "tabs" from the margin. I would appreciate any insight. SAS 9.4 TS Level 1M2, Windows 7 Pro 64 bit, MS Office 2013 Here is a code snippet, with the area in question in bold (near the bottom): ods tagsets.Excelxp file='<...\faculty-f14.xml' style=printer options(sheet_name="Tenure Track" sheet_interval='proc' width_fudge='0.5' frozen_headers='yes' frozen_rowheaders='1' embedded_footnotes='yes' index='yes'); proc report data=ttheads4 nowd style(header)={font_face='Calibri'} style(column)={font_face='Calibri' tagattr='format:##,###;-##,###;0' /*backgroundcolor=#FFFFFF*/}; /*style(lines)={font_face='Calibri' backgroundcolor=#FFFFFF};*/ footnote bcolor='#FFFFFF' "*Figures include faculty who are on leave without pay, on sabbatical."; footnote2 bcolor='#FFFFFF' "**Faculty with split appointments are counted in only their berth department."; column description schlrank divrank unitrank factype _&ym9 _&ym8 _&ym7 _&ym6 _&ym5 _&ym4 _&ym3 _&ym2 _&ym1 _&year; define description /display ''; define schlrank /display noprint ''; define divrank /display noprint ''; define unitrank /display noprint ''; define factype /display noprint ''; define _&ym9 /display "&yyyym9"; define _&ym8 /display "&yyyym8"; define _&ym7 /display "&yyyym7"; define _&ym6 /display "&yyyym6"; define _&ym5 /display "&yyyym5"; define _&ym4 /display "&yyyym4"; define _&ym3 /display "&yyyym3"; define _&ym2 /display "&yyyym2"; define _&ym1 /display "&yyyym1"; define _&year /display "&yyyy"; column shading; define shading /computed noprint ''; compute shading; if schlrank in (1) and factype in (1) then do; call define (_ROW_ , 'STYLE', 'STYLE=[BACKGROUNDCOLOR=#006A4E COLOR=#FFFFFF FONTWEIGHT=BOLD]'); end; if schlrank in (1) and factype gt 1 then do; call define (_ROW_ , 'STYLE', 'STYLE=[BACKGROUNDCOLOR=#BBC5AF COLOR=#000000 FONTWEIGHT=BOLD]'); end; if schlrank gt 1 and factype in (1) then do; call define (_ROW_ , 'STYLE', 'STYLE=[BACKGROUNDCOLOR=#A8A8A8 COLOR=#000000 FONTWEIGHT=BOLD]'); end; if schlrank gt 1 and divrank gt 1 and factype in (1) then do; call define (_ROW_ , 'STYLE', 'STYLE=[FONTWEIGHT=BOLD]'); end; if schlrank gt 1 and divrank gt 1 and unitrank in (1) and factype in (1) then do; call define (_ROW_ , 'STYLE', 'STYLE=[BACKGROUNDCOLOR=#E6E6E6 COLOR=#000000 FONTWEIGHT=BOLD]'); end; if schlrank gt 1 and divrank gt 1 and unitrank in (1) and factype gt 1 then do; call define (_ROW_ , 'STYLE', 'STYLE=[FONTWEIGHT=BOLD]'); end; if factype in (2,6) then do; call define ("description" , 'STYLE', 'STYLE=[INDENT=2]'); end; if factype in (3,4,5) then do; call define ("description" , 'STYLE', 'STYLE=[INDENT=4]'); end; endcomp; run; ods tagsets.Excelxp close;
... View more
