|Date: ||Wed, 10 May 2006 11:30:41 -0400|
|Reply-To: ||Dianne Rhodes <RHODESD1@WESTAT.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Dianne Rhodes <RHODESD1@WESTAT.COM>|
|Subject: ||Re: ODS Tagsets ExcelXP|
|Content-Type: ||text/plain; charset="us-ascii"|
> From: email@example.com
> [mailto:firstname.lastname@example.org] 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