This is what I had after I installed Service Pack 4:
NOTE: This is the Excel XP tagset (SAS 9.1.3, v1.28, 08/29/05)
Since the latest tagset is from June 07, you're better off downloading the newest tagset after you install Service Pack 4. Running this program (below) will not only show you the date, but will also show you the features/options included in the tagset (they'll be in the SAS Log).
I have SAS 9.1.3 SP4 and Excel 2000 in my computer.
I ran the same code in my SAS, but the generated Excel file looks like an XML file. I can't figure out why.
Here is the part of the Excel file:
xmlns:html="http://www.w3.org/TR/REC-html40"> lil602 lil602 2009-03-03T12:16:39 2009-03-03T12:16:39 SAS Institute Inc. http://www.sas.com 9.01.01M3P02022006
TAGSETS.EXCELXP does create XML -- it is Spreadsheet Markup Language XML that conforms to the Excel 2003 specification for an XML description of a Workbook and worksheets within that workbook.
For Excel to be able to render the XML that ODS creates, you have to use either Excel 2002, 2003 or higher. I believe that if you open the XML with Excel 2000, then you will see the unrendered XML -- which sounds like what's happening.
If you only have Office 2000/Excel 2000 available to you, then your choices are
1) use ODS MSOFFICE2K and create an HTML file (which will only give you 1 worksheet per workbook by default) or
2) upgrade your Office/Excel to at least 2002 or 2003.
Thank you for your quick response. I thought Excel 2000 can read XML because I saw this in a paper (http://support.sas.com/rnd/base/ods/odsmarkup/p236-31.pdf, please see page 11). I am going to try ODS MSOFFICE2K.
Perhaps that's a typo in the paper or perhaps Microsoft issued a plug-in to make Office 2000 read Spreadsheet ML. I don't know which one applies. I know that when I tried (on a different computer) to open Spreadsheet ML files in Excel 2000, I only saw the unrendered XML. Now that I have Office 2007 on that computer, I can no longer do a test. You might want to check with Tech Support for sure.
But I could not find any references to Excel 2000 being used with Spreadsheet Markup Language XML on the Microsoft site. In this blog, by Brian Jones (of Microsoft), I did find this Intro to Spreadsheet ML: http://technet.microsoft.com/en-us/magazine/2006.01.blogtales.aspx
in which he says:
"To get you started, I’ll build a sample in XML that will illustrate how it all works. As you follow along, you can use Office XP or Office 2003 for this example since both support SpreadsheetML in their versions of Excel." (He doesn't refer to Office 2000. I thought Office XP was Office 2002.)