topic Re: Reading XML from a table in SAS Programming

Reading XML from a table

NG_cap — Tue, 11 Apr 2017 07:56:00 GMT

Hi,

I have a table with XML data stored in an column of an MySQL table. I would like to read and parse the data into individual tables.

All the example that I have found read the data from a xml file. I have the map file ready to parse the data.

How do I import such stored data?

-NG

Re: Reading XML from a table

RW9 — Tue, 11 Apr 2017 08:55:03 GMT

Well, the simplest way, without looking at documentation to see if direct code is possible, is to just read the database as string, and write it out to a temporary file. Then import it in using normal methods and your map file. I know its writing out and reading in but its only a few lines of code.

Re: Reading XML from a table

abhityagi — Tue, 11 Apr 2017 09:50:42 GMT

Please go thru from the given belo link pdf. you will get the idea.

http://scsug.org/SCSUGProceedings/2008/papers/app/Mayumi_Takada.pdf

Thanks,

Abhi

Re: Reading XML from a table

NG_cap — Tue, 11 Apr 2017 12:44:10 GMT

With all the reading and writing, this will soon become a time consuming process. I would rather have a way to directly read the data and then parse it using a map.

This might be the hail mary option.