Date: Fri, 10 Sep 2010 12:29:05 -0500
Reply-To: AnnHett <annhett@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: AnnHett <annhett@GMAIL.COM>
Subject: Re: SAS and XML
In-Reply-To: <95F237EC5A175641913116473AEAD8571AE448@LTA3VS001.ees.hhs.gov>
Content-Type: text/plain; charset=ISO-8859-1
I've been majorly sidetracked. I have to get back on this today. We have
SAS 9.3, so I think I will first upgrade, then start trying things. I need
to get this working soon.
Thanks everyone! I might have more questions once I have some time to work
on it.
ann
On Thu, Aug 26, 2010 at 9:25 AM, Gerstle, John (CDC/OID/NCHHSTP) <
yzg9@cdc.gov> wrote:
> As I'm presently working on reading in complex XML data, I can say that v92
> is better equipped to deal with complex XML. From what I'm reading, I think
> the SAS XMLMapper is a stand alone download. It does not depend on the SAS
> version, so you could install it and use it to create Map files from the XML
> data file.
>
> In v913, there is only the XML engine for LIBNAME. You can use the
> XMLMapper to create a Map version 1.2 that can be used by XML engine. In
> v92 (phase 2), you have XML and XML92 engines, where the latter is an
> upgrade allowing for more control in reading/writing XML files.
>
> The XMLMapper is nice, once you start playing with it. If you have either
> an XML data file or a schema file (XSD), you can auto-generate the Map file
> that will help the XML engine read the data correctly. It will list the
> attributes and elements, each can be manually modified for length, format,
> name, etc.
>
> If anything, you can use the XMLMapper to auto-generate the Map file then
> take the file and modify as needed outside of the mapper.
>
>
> http://support.sas.com/documentation/cdl/en/engxml/62845/PDF/default/engxml.pdf
>
> hope that's a little helpful...
>
> John Gerstle
> Scientific Information Specialist
> Centers for Disease Control and Prevention
> NCHHSTP\DHAP-SE\QSDMB\Data Management Team
> Phone: 404-639-3980
> Fax: 404-639-8642
> Email: yzg9 at cdc dot gov
> Socrates, proclaimed: "I came to know one thing; that I know nothing".
>
> "Every question I answer will simply lead to another question."
>
> >>-----Original Message-----
> >>From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
> On
> >>Behalf Of Ken Barz
> >>Sent: Wednesday, August 25, 2010 11:58 PM
> >>To: AnnHett; SAS-L@listserv.uga.edu
> >>Subject: Re: SAS and XML
> >>
> >>Depending on your install method (disks or software depot) if you start
> the
> >>install process, there should be a check box for the XML Mapper. I don't
> >>know if 9.1.3 Mapper is available as a separate download. Also in the
> SAS
> >>XML documentation, they do spell out the syntax for how to manually
> create
> >>and use an XML map without the mapper application. If your XML is really
> >>complex, Mapper can get confused so you may have to go manual anyway.
> >>
> >>----- Original Message -----
> >>From: "AnnHett" <annhett@GMAIL.COM>
> >>To: <SAS-L@LISTSERV.UGA.EDU>
> >>Sent: Wednesday, August 25, 2010 4:25 PM
> >>Subject: SAS and XML
> >>
> >>
> >>Does anyone have experience with importing XML into SAS?
> >>
> >>I'm unable to use the libname in xml 'path'; because my data is too
> >>complicated.
> >>We don't seem to have XML mapper as part of our
> >>SAS license. I've found a download for XML Mapper for 9.2, but I have
> >>9.1.3. Is it available for 9.1.3?
> >>
> >>Does anyone have any experience with a data step or another way?
> >>
> >>Thanks,
> >>ann
>
>
>
| 
