topic Create XML file, change root tag in SAS Programming

Create XML file, change root tag

ThierryHerrie — Tue, 15 Oct 2019 13:47:34 GMT

Hi,

I'm creating a XML file using the XMLV2 library engine. The code looks like this:

FILENAME MyXML "&dir.\kip.xml" ;
LIBNAME MyXML XMLV2 XMLENCODING=utf8 ;

DATA MyXML.Klas ;
  SET sashelp.class (OBS=1) ;
RUN ;

LIBNAME MyXML CLEAR ;
FILENAME MyXML CLEAR ;

It successfully creates a XML file. However I would like to change 2 things. If you look at the XML file

<?xml version="1.0" encoding="utf-8" ?>
<TABLE>
   <KLAS>
      <Name>Alfred</Name>
      <Sex>M</Sex>
      <Age>14</Age>
      <Height>69</Height>
      <Weight>112.5</Weight>
   </KLAS>
</TABLE>

I would like to change the root tag to Klassen and the upcase KLAS to Klas. So it looks like this:

<?xml version="1.0" encoding="utf-8" ?>
<Klassen>
   <Klas>
      <Name>Alfred</Name>
      <Sex>M</Sex>
      <Age>14</Age>
      <Height>69</Height>
      <Weight>112.5</Weight>
   </Klas>
</Klassen>

Is there any way to do this?

Thierry

Re: Create XML file, change root tag

Tom — Tue, 15 Oct 2019 14:14:13 GMT

You probably will need to create a map file.

https://documentation.sas.com/?docsetId=engxml&docsetTarget=p030dni55gms3qn1xxc7xxpzn06p.htm&docsetVersion=9.4&locale=en

Or you could just post-process the file.

data _null_;
  infile  "&dir.\kip.xml" ;
  file  "&dir.\kip_fixed.xml" ;
  input ;
  if _infile_ = '<TABLE>' then _infile_='<Klassen>';
  else if _infile_ = '</TABLE>' then _infile_='</Klassen>';
  else if left(_infile_)='<KLAS>' then _infile_='<Klas>';
  else if left(_infile_)='</KLAS>' then _infile_='</Klas>';
  put _infile_;
run;

Re: Create XML file, change root tag

ThierryHerrie — Tue, 15 Oct 2019 17:40:17 GMT

Postprocessing the file was my plan B

Think I will just do that, thanks!