I'll try again with a sample data set... data test ; input file $ campaign clicks cost ; cards ; test 15 426447 234524.22 test 15 357663 234324.59 ctrl 15 134346 198709.47 ctrl 15 687967 908784.59 ; run; ods listing close ; ods tagsets.excelxp file = "test.xls" options(embedded_titles='yes' embedded_footnotes='yes' print_header='yes' print_footer='yes' suppress_bylines='yes' sheet_interval='none'); proc ttest data = test alpha = 0.2 cochran plots=none ; class file ; freq campaign ; var cost clicks ; title 'Ttest - Test file'; run; ods tagsets.excelxp close ; ods listing ; quit; As you can see from running the code above, the variable name appears in the HTML output "Variable: cost." Also the frequency name appears as "Frequency: campaign." Neither naturally appear at all in the Tagset output. Specifically Tagsets does not seem to capture all titles naturally included by SAS HTML output. Yes, I could wrap a macro around PROC TTEST and place the variable and frequency names in the title each time I run the PROC. However I hoped for a solution that would use Tagsets to capture the variable name appearing all the PROCTITLEs executed behind the scenes as SAS creates the HTML output (right-click on HTML output window, view source, Notepad opens to reveal...): <div class="c proctitle">The TTEST Procedure</div> <div class="c proctitle"> </div> <div class="c proctitle">Variable: cost</div> This problem extends to NPAR1WAY as well. Probably all PROCs that do not include variable name as tabular output. I hope that's more clear. Thank you for taking the time read.
... View more