I am using the option tagsets.ExcelXP to "export" my SAS procedures to Excel. At the moment, even though a title is entered and is displaying in the SAS html file created, no title appear in the Excel I'm creating.
Here is the code I'm using (simplified for your benefit) :
(You might want to post ODS questions to the ODS Forum in the future...)
With the TAGSETS.EXCELXP destination, you are NOT creating HTML files. You are creating Spreadsheet Markup Language XML files that comply with the Microsoft Office 2003 XML specification for workbooks/worksheets.
By default, the SAS title is put into the "print header" of the worksheet. So you should see it in Print Preview mode.
Otherwise, if you invoke the tagset with the suboption doc="Help", you will see that there are some other suboptions you can specify that will put the titles into the body of the worksheet. Try this:
ods tagsets.ExcelXP file='c:\temp\title.xls' style=sasweb
proc print data=sashelp.class;
title 'this is the title';
ods _all_ close;
The help information will be in the SAS log after this program runs.