How to modify the root element and the instance of element in an XML file

alepage — Thu, 16 Aug 2018 13:20:55 GMT

Hello,

Here's the situation...

When I execute the code below, I am getting an xml file (see the partial file below).

The root element is TABLE and instances of element are CLASS.

Is there a nice and simple way to change TABLE for ROWSETS and CLASS for ROW.

Regards,

***********************************************************************************************************************

libname export xml "\\...\Documents\Test\Temp\class.xml";

Data Temp;

set sashelp.class;

run;

data export.class;

set sashelp.class;

run;

/* Here's the partial content of the xml file

The root element is TABLE and instances of element are CLASS

<?xml version="1.0" encoding="windows-1252" ?>

<TABLE>

<CLASS>

<Name> Alfred </Name>

</CLASS>

<CLASS>

<Name> Alice </Name>

</CLASS>

topic Re: How to modify the root element and the instance of element in an XML file in SAS Enterprise Guide