DATA Step, Macro, Functions and more

Reading XML from SAS

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 93
Accepted Solution

Reading XML from SAS

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

 


Accepted Solutions
Solution
‎06-13-2017 12:09 PM
Moderator
Posts: 238

Re: Reading XML from SAS


All Replies
Super User
Super User
Posts: 7,401

Re: Reading XML from SAS

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.

Solution
‎06-13-2017 12:09 PM
Moderator
Posts: 238

Re: Reading XML from SAS

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

Super User
Posts: 9,681

Re: Reading XML from SAS

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;
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 125 views
  • 1 like
  • 4 in conversation