topic Re: Need to read an XML File in SAS Programming

Need to read an XML File

e044800 — Thu, 09 Feb 2017 17:25:08 GMT

Hi,

I am facing tough time in reading an XML file as i have never done it before in SAS.

Can anyone help me in reading a sample XML file attached(the file extention has been changed as doc as i was not able to upload the xml file)

Can we read it using any XML engine available in Libname statement (if any)

It would also be good if any effective helpful learning material referance could also be provided.

Thanks

Lokesh

Re: Need to read an XML File

FriedEgg — Thu, 09 Feb 2017 17:42:06 GMT

filename xx temp;
libname acrp xmlv2 "C:\temp\acrp.xml" automap=replace xmlmap=xx;

Using the free Xml Mapper tool from SAS instead of the automap will probably suit you better

https://support.sas.com/downloads/package.htm?pid=1278

Re: Need to read an XML File

e044800 — Tue, 14 Feb 2017 03:56:50 GMT

HI,

Thanks for your reply and help.

I did try the same code to read the XML files but its creating blank files and no observation is coming into it.

Not able yo resolve.

Kindly help.

Thanks

Re: Need to read an XML File

e044800 — Tue, 14 Feb 2017 05:39:57 GMT

I used the xml mapper tool as well instead of automap but the results are same.

What else i may try.

Thanks

Re: Need to read an XML File

Patrick — Tue, 14 Feb 2017 05:55:38 GMT

The code @FriedEgg posted works for me with the file you've provided (once I've renamed it to the name FriedEgg uses).