Reading XML from SAS

[juanvg1972]

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]

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

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

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

[AndrewHowell · Accepted solution]

Have you tried the SAS XML mapper (click here)?

[Ksharp]

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;