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
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 Thu, Aug 26, 2010 at 9:25 AM, Gerstle, John (CDC/OID/NCHHSTP) <
> 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.
> 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: email@example.com [mailto:firstname.lastname@example.org]
> >>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
> >>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
> >>XML documentation, they do spell out the syntax for how to manually
> >>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
> >>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?