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.

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 Chris Bat >>Sent: Monday, July 25, 2011 8:48 AM >>To: SAS-L@LISTSERV.UGA.EDU >>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; >>format LoginName; >>run; >> >>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 >>variables. >> >>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 >>Chris