topic Re: Reading XML from SAS in SAS Programming

Reading XML from SAS

juanvg1972 — Tue, 13 Jun 2017 13:02:31 GMT

Hi,

I need to read an XML from SAS. I am using this;

libname xmltrans XML 'C:\temp\xmlprueba\prueba.xml';


data sasdesdexml;
set xmltrans.prueba;
run;

This works when my XML is very simple, but it dosen't work in complex XML

Is there any other option to read XML from SAS

Thanks in advance

RW9 — Tue, 13 Jun 2017 13:06:04 GMT

Well, the obvious answer here is the XMLMapper tool from SAS:

This can do more complex importing. If you need further, stylesheets/DSD etc. then consider an XL specific program.

AndrewHowell — Tue, 13 Jun 2017 13:06:45 GMT

Ksharp — Tue, 13 Jun 2017 13:58:20 GMT

Try xmlv2 engine .

filename tmp temp;
libname xx xmlv2 '/folders/myfolders/class.xml' xmlmap=tmp automap=replace;
proc copy in=xx out=work noclone;
run;