Hi:
When I run this code (which uses SASHELP.CLASS):
[pre]
ods listing close;
ods tagsets.ExcelXP path="c:\temp"
file="test.xls"
style=analysis;
ods tagsets.ExcelXP options(embedded_titles='yes'
embedded_footnotes='yes');
run;
ods tagsets.ExcelXP options(sheet_name='age');
Proc Report data=sashelp.class nowd;
title 'The title';
footnote 'The footnote';
column name sex age height weight;
define name / display 'CurrentInventory';
define sex / display 'Previous';
define age / display 'Worked';
define height / display 'NewItems';
define weight / display 'Count';
run;
ods tagsets.ExcelXP close;
run;
ods listing;
[/pre]
I do get the output. In order to see the output, I have to click YES when I get the following message from Office/Excel 2010:
The file you are trying to open xxxxxxx.yyy is in a different format than specified by the file extension. verify the file is not corrupted and is from trusted source before opening the file. Do you want to open the file now?
This is an accurate message. When you use TAGSETS.EXCELXP, you are not creating a 'true, binary" Excel file. You are creating an Office 2003 Spreadsheet Markup Language XML file that Excel knows how to open and render. When you give the file an extension of ".xls", you are merely fooling the Windows registry into launching Excel when you double click on the file name. In order to open the file, you must click YES when you see this message. (as explained in this Tech Support note:
http://support.sas.com/kb/35/581.html )
When I run my code, I see the following in the SAS log:
[pre]
NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.94, 09/09/12). Add
options(doc='help') to the ods statement for more information.
[/pre]
The only other thing I can think of is that you are running an older version of TAGSETS.EXCELXP.
Otherwise, for help with your issue, you might want to work with Tech Support. It does not look to me like you should be having any issues with your code.
cynthia