> From: owner-sas-l@listserv.uga.edu > [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of Gerstle, > John (CDC/NCHSTP/DHAP) (CTR) > > > Ah, I see a new version, May 10, 2006 is the date stamp on > the file to download. > > Interesting issue though... > > I just ran this code: > ODS tagsets.excelxp > file="Y:\SAS Programs\Tagsets\ExcelXPHelpMay2006.xml" > options(doc="help") ; > ods tagsets.excelxp close; > > And the resulting file, "ExcelXPHelpMay2006.xml", cannot be > read by Excel (error window pops up and says: "Unable to read file"). > > When I am able to get it open (via MSWord, showing the XML > tags) there isn't any text besides the header information > (unless the font color is white), just lots of border tags > and paragraph symbols (placed there by > Word) - no text. > > There is text in the LOG. > >

What were you expecting to be in the file? The DOC option writes to the Log. You need a proc print or something that generates output to ODS. I've been doing this with proc tabulate, and I right click on the file from Windows and select Open with Excel. Very nice formatted output.

Dianne Rhodes @ westat