topic Re: SAS code for XML file in SAS Programming

SAS code for XML file

Babloo — Thu, 18 Jan 2018 15:32:08 GMT

Is there any way to create a SAS code to produce a dataset from the following XML?

<?xml version="1.0" encoding="iso-8859-1" ?>
<NHL>
  <CONFERENCE> Eastern 
    <DIVISION> Southeast  
      <TEAM name="Thrashers"  abbrev="ATL" />  
   </DIVISION>
 </CONFERENCE> 
</NHL>

Re: SAS code for XML file

Reeza — Thu, 18 Jan 2018 15:54:29 GMT

@Babloo wrote:

Is there any way to create a SAS code to produce a dataset from the following XML?
<?xml version="1.0" encoding="iso-8859-1" ?>
<NHL>
  <CONFERENCE> Eastern 
    <DIVISION> Southeast  
      <TEAM name="Thrashers"  abbrev="ATL" />  
   </DIVISION>
 </CONFERENCE> 
</NHL>

Yes, XML Mapper or XML libname. Or you can always parse it manually...sometimes that ends up being the fastest solution.

Re: SAS code for XML file

Babloo — Thu, 18 Jan 2018 15:59:35 GMT

Is there any way that you can help me create the SAS code for the above
example?

Re: SAS code for XML file

Reeza — Thu, 18 Jan 2018 16:08:29 GMT

Same as every other question, show what you have, what you expect as output and what you've tried and you'll get help.

Re: SAS code for XML file

Cynthia_sas — Thu, 18 Jan 2018 16:28:10 GMT

Hi:
What code have you tried? For example, this Tech Support note seems to have an example of reading the NHL xml file using an XML Map: http://support.sas.com/documentation/cdl/en/engxml/62845/HTML/default/viewer.htm#a002484891.htm
cynthia

Re: SAS code for XML file

gamotte — Thu, 18 Jan 2018 16:38:38 GMT

Hello,

Try the following SAS code :

filename xmldata "c:\temp\test XML SAS\test.xml";
filename xmlmap  "c:\temp\test XML SAS\mapping.map";
libname  xmldata xml xmlmap=xmlmap;


data test;
set xmldata.mytable;
run;

With test.xml the XML file you described and mapping.map as follows

<SXLEMAP version="1.2" name="SXLEMAP">
    <TABLE name="mytable">
        <TABLE-PATH syntax="XPATH">
           /NHL/CONFERENCE/DIVISION/TEAM
         </TABLE-PATH>
        <COLUMN name="Conference">
            <PATH syntax="XPath">/NHL/CONFERENCE</PATH>
            <TYPE>character</TYPE>
            <DATATYPE>string</DATATYPE>
            <LENGTH>10</LENGTH>
        </COLUMN>
        <COLUMN name="Division">
            <PATH syntax="XPath">/NHL/CONFERENCE/DIVISION</PATH>
            <TYPE>character</TYPE>
            <DATATYPE>string</DATATYPE>
            <LENGTH>10</LENGTH>
        </COLUMN>
        <COLUMN name="Team">
            <PATH syntax="XPath">/NHL/CONFERENCE/DIVISION/TEAM@name</PATH>
            <TYPE>character</TYPE>
            <DATATYPE>string</DATATYPE>
            <LENGTH>10</LENGTH>
        </COLUMN>
        <COLUMN name="Abbreviation">
            <PATH syntax="XPath">/NHL/CONFERENCE/DIVISION/TEAM@abbrev</PATH>
            <TYPE>character</TYPE>
            <DATATYPE>string</DATATYPE>
            <LENGTH>10</LENGTH>
        </COLUMN>
    </TABLE>
</SXLEMAP>

Re: SAS code for XML file

Babloo — Fri, 19 Jan 2018 05:13:26 GMT

Received the following error. Could you please guide me to resolve the issue?

24         data test;
25         set xmldata.mytable;
ERROR: Physical file does not exist, /wrk1/mapping.map.
       encountered during XMLMap parsing
       occurred at or near line 1, column 1
ERROR: XML describe error: Internal processing error.
26         run;

Re: SAS code for XML file

gamotte — Fri, 19 Jan 2018 08:22:58 GMT

Hello,

It is written in the log :

ERROR: Physical file does not exist, /wrk1/mapping.map

Check that the path to your map file is correct.

Re: SAS code for XML file

Babloo — Fri, 19 Jan 2018 08:32:35 GMT

Path is correct.But I don't have that .Map file in that folder.

Re: SAS code for XML file

gamotte — Fri, 19 Jan 2018 08:37:50 GMT

You have to create it there with the contents i provided in my first answer.

Re: SAS code for XML file

Babloo — Fri, 19 Jan 2018 09:13:37 GMT

Is there any way to format a XML file which has repetitive elements?

Re: SAS code for XML file

Babloo — Fri, 19 Jan 2018 09:33:35 GMT

Can we also create the mapping.map via SAS XML mapper?

Re: SAS code for XML file

gamotte — Fri, 19 Jan 2018 09:48:10 GMT

Yes, you can use XML mapper to create the map file as suggested by @Reeza.

Re: SAS code for XML file

maggiem_sas — Mon, 22 Jan 2018 18:39:45 GMT

Here is the most recent version of the XML engine book, opened at the topics that discuss the XML Mapper: Using SAS XML Mapper to Generate and Update an XMLMap.

See also two videos about XMLMaps listed under "Videos" at http://support.sas.com/documentation/onlinedoc/base/index.html