|Date: ||Mon, 25 Jul 2011 14:58:14 +0000|
|Reply-To: ||"Gerstle, John (CDC/OID/NCHHSTP)" <yzg9@CDC.GOV>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Gerstle, John (CDC/OID/NCHHSTP)" <yzg9@CDC.GOV>|
|Subject: ||Re: XML import question|
|Content-Type: ||text/plain; charset="iso-8859-1"|
I think you need to look into using the SAS XML Mapper to assist in importing your XML file(s). The mapper is a stand-alone product included with the SAS install.
Once you've created a map, you add the option to the XML libname statement, and run.
Scientific Information Specialist
Centers for Disease Control and Prevention
NCHHSTP\DHAP-SE\QSDMB\Data Management Team
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."
>>From: email@example.com [mailto:firstname.lastname@example.org] On
>>Behalf Of Chris Bat
>>Sent: Monday, July 25, 2011 8:48 AM
>>Subject: XML import question
>>Funny that both Sagar and I have XML questions this morning.
>>1) How does one import XML using Enterprise Guide? I've tried and the
>>File Types drop box doesn't have XML as an option. I selected All File
>>types and then navigated to my file, but EG treated it as Delimited file.
>>2) Using SAS 9.2, I am using the following code (taken from the XML
>>LIBNAME User's Guide, on importing XML with numeric data):
>>libname default xml 'D:\data.xml';
>>title 'Default Method';
>>proc print data=work.xmltest;
>>where my SAS Table only has one column, LoginName (although my XML file
>>has many more fields, I wanted to start off with one).
>>When I run the SAS Code above, and a couple of others from the User's
>>Guide, it runs but I get notes in my log that 0 observations and 0
>>Is it a problem with my XML formatting? I don't know much about XML, the
>>file is automatically generated by one of our systems; I'm really hoping
>>it's a problem with my SAS, as that'll be much easier to fix.
>>Thanks in advance