topic Re: Export SAS DATA set in XML in SAS Programming

Export SAS DATA set in XML

SAS_Deepak — Tue, 02 Feb 2021 15:34:15 GMT

Hi Guys,

I want to export the SAS Data set in XML through SAS code.

How I can do that?

Do the needful.

Thanks and Regards.

Re: Export SAS DATA set in XML

CarmineVerrell — Tue, 02 Feb 2021 15:42:03 GMT

Take a look at this..
https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/119-29.pdf

Re: Export SAS DATA set in XML

SASJedi — Tue, 02 Feb 2021 17:47:43 GMT

The simplest method is to use the SAS LIBNAME XMLV2 engine. Something like this would work:

filename classXML 'C:\temp\class_data.xml';
libname classXML xmlv2;
proc copy in=sashelp out=classXML;
   select class;
run;
libname classXML clear;
filename classXML clear;

This produces the following XML file:

<?xml version="1.0" encoding="windows-1252" ?>
<TABLE>
   <class>
      <Name>Alfred</Name>
      <Sex>M</Sex>
      <Age>14</Age>
      <Height>69</Height>
      <Weight>112.5</Weight>
   </class>
   <class>
      <Name>Alice</Name>
      <Sex>F</Sex>
      <Age>13</Age>
      <Height>56.5</Height>
      <Weight>84</Weight>
   </class>
</TABLE>

Re: Export SAS DATA set in XML

SAS_Deepak — Tue, 09 Feb 2021 07:21:35 GMT

Thank you