Date:         Mon, 19 Sep 2005 16:54:35 -0600
Reply-To:     Alan Churchill <SASL001@SAVIAN.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alan Churchill <SASL001@SAVIAN.NET>
Subject:      Re: use multiple tagsets in XML?
Comments: To: jfh@stanfordalumni.org
In-Reply-To:  <20050919162347.85434.qmail@web53715.mail.yahoo.com>
Content-Type: text/plain; charset="us-ascii"

Jack,

Per the Microsoft website:

Q. Will there be an XML file converter for people using previous releases
that don't support XML?

A. Yes. Microsoft will release converters for Microsoft Office 2000,
Microsoft Office XP, and Microsoft Office 2003, so customers using previous
releases of Microsoft Office will be able to open files created using the
new file formats.

Btw, if anyone wants to see the new screenshots of Office 12, you can see a
few of them here:

http://www.microsoft.com/presspass/features/2005/sep05/09-13OfficeUI.mspx

The screenshots do not do it justice, btw. Promises to be exciting.

Alan Churchill
Savian "Bridging SAS and Microsoft Technologies"
www.savian.net


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Jack
Hamilton
Sent: Monday, September 19, 2005 10:24 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: use multiple tagsets in XML?

ODS doesn't write a native-format Excel file.  It writes an HTML or XML
file that recent versions of Excel know how to read.

If you don't know what version of Excel your recipients may have,
you'll have to read and resave the file yourself, being careful to
change the file format to one that the recipients will understand.  The
Excel 96 format is pretty safe - most recpients will not have a version
of Excel that's more than seven years old.

When Microsoft switches to XML as the native format for Excel files,
SAS might be able to write native-format files, but that won't help in
your case - the recipients would still need to have the latest version
of Excel (though perhaps Microsoft will provide a converter).



--- Susie Li <Susie.Li@TVGUIDE.COM> wrote:

> I'm trying to use tagsets... to write out Excel files.  But the
> recipient
> couldn't read the Excel output.  I suspect that it has something to
> do the
> XML format that older Excel cannot recoginize.
>
> Please educate me on this format.
>
> Susie Li
> TV Guide
> 1211 Avenue of the Americas
> New York, NY 10036
> Tel 212.852.7453
> Email susie.li@tvguide.com
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> kevinjmorris@GMAIL.COM
> Sent: Friday, September 16, 2005 2:57 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: use multiple tagsets in XML?
>
> I am using the XML LIBNAME engine to export a SAS DataSet to an XML
> file.  Unfortunately, SAS does several annoying things by default:
>
> 1 - it puts a space between the XML tags and the data.
>     EX: <tag> data </tag>.
> 2 - if data is missing, it inserts the word "missing" into the tag.
>     EX: <tag Missing="." />
>
> There are two different tagsets that resolve these issues:
> 1 - tagsets.sasxmnsp -- produces: <tag>data</tag>
> 2 - tagsets.sasxmiss -- produces: <tag />
>
> My problem is that I want to take advantage of both of these tagsets
> for my XML data.  Is there a way I can somehow "combine" both of
> these
> tagsets in the LIBNAME statment by some other means?  I have tried
> the
> following:
>
> LIBNAME dbaxml xml
>   "c:\temp.xml"
>   tagset=tagsets.sasxmiss
>   tagset=tagsets.sasxmnsp;
>
> and it only seems to pick up the last one in the list.
>
> Any ideas?
>
> Thanks.
>
>