topic Re: read-in a XML-file in SAS Programming

read-in a XML-file

grimol — Tue, 21 Jul 2015 08:05:32 GMT

Hello,

how can I readin this type of XML-File in SAS? How the xmlmap-file must look like?

<?xml version="1.0"?>

<table>

<row>

<column>Spalte2</column>

<column>Spalte3</column>

<column>Spalte4</column>

<column>Spalte5</column>

<column>Spalte6</column>

<column>Spalte7</column>

<column>Spalte8</column>

</row>

<row>

<column>gfdgfd</column>

<column>hgdgfdf</column>

<column>gfdgfdfgd</column>

<column>Deutschland</column>

<column>gfdgfd</column>

</row>

<row>

<column>weqwe</column>

<column>qeqwe</column>

<column>Deutschland</column>

<column>ewqweq</column>

</row>

</table>

Re: read-in a XML-file

BillM_SAS — Tue, 11 Aug 2015 15:42:31 GMT

If you are running the second maintenance release of SAS 9.3 or later, you can use the AUTOMAP option of the XMLV2 Libname engine:

LIBNAME X XMLV2 "<path to XML file>" AUTOMAP=REPLACE XMLMAP="<path to XML Mapper file created>";

You will need to supply your site specific information for the places I used angle brackets, < >. This will create 3 data sets. The one of interest will be the Columns data set.

If you are running a version of SAS that does not support the AUTOMAP option, you will need to use the XML Mapper application. It is a free download from the SAS Customer Support Knowledge Base and Community web site.

You may also want to read a paper I presented at the 2013 SAS Global Forum that has sections dealing with XML data. The paper is titled, "The Ins and Outs of Web-Based Data with SAS". You can access the paper at:

Technical Papers and Presentations made by SAS staff

The AUTOMAP option is discussed on page 7.

Re: read-in a XML-file

grimol — Mon, 17 Aug 2015 07:09:05 GMT

PERFECT. Thank you. I've tried the XML-Mapper but I didnt get the result I want. With the AUTOMAP-Option it works!