I am trying to output the results from PROC TTEST on 8 variables using ODS TAGSETS.EXCELXP. However, the title in between the individual PROC TTESTs does not show up, making it hard to identify the individual variables. ods _all_ close; ods tagsets.ExcelXP path='filepath' file='filename.xml' style=printer options(sheet_interval='Proc' embedded_titles="yes" embedded_footnotes="yes" skip_space='3,0,1,1,1' contents='yes'); options helpbrowser=sas; ods tagsets.ExcelXP options(sheet_name='sheet1'); proc ttest data=data1; class var1; var var2 var3 var4 var5 var6 var7 var8 var9; title 'Proc ttest'; title2 'data1'; run; ods tagsets.ExcelXP close; In the output from PROC TTEST (not ODS) the first 2 lines are: The TTEST Procedure Variable: var1 This does not transfer to the Excel file. Why>
... View more