Hello everyone, I am trying to use ODS tagsets.excelxp in Sas V9.3 on a system that has Microsoft Excel 2010 installed. Here is the simplified version my code: ODS TAGSETS.EXCELXP file="C:\file.xls" OPTIONS(EMBEDDED_TITLES='YES' EMBEDDED_FOOTNOTES='YES'); PROC TABULATE DATA=test MISSING; CLASS PGM YEAR; TABLE PGM, YEAR; RUN; ODS TAGSETS.EXCELXP CLOSE; The problem: After I run the code, an excel file is produced in the target location. If I double click to open, Excel does not open and instead I get this "Microsoft Excel has stopped working". If i open the file from inside excel, it opens fine after I get a warning telling me the file is in a different format from that specified by the extension. Once open, if i go file>saveas, the default 'save as type' is XML spreadsheet 2003. If change this to xls and save then the file opens fine when i simply double-click it. Is there any way of getting around having this extra step? I have tried instead tagsets.msoffice2k. I have tried putting ODS _all_ close before the bit of code. And I recently installed microsoft data connectivity components which sorted out my proc import issues with excel. However none of these have resolved this issue i have described. Any suggestions would be appreciated! Thank you! Sarasvati
... View more