How to create an xml file from a SAS table

shlomiohana — Sun, 24 Oct 2021 18:35:12 GMT

Hello,
I want to create an xml file from a SAS table with a hierarchy.
The table has the following 8 fields:
atmld, bankcode, bankbranchcode, schum, dt, monthreport, cuerrentdate, factorcode.
Example of how I would like the xml file to be displayed.

I will ask for your help on how to write the code.

Re: How to create an xml file from a SAS table

Cynthia_sas — Sun, 24 Oct 2021 19:03:36 GMT

Hi:
The ways I know about are:
1) using the XML Libname engine with an XML Map
2) using the XML Libname engine with an XSL Schema
3) using a DATA step program
4) writing a custom tagset template
You would need to read about how the XML Libname Engine works by default and then figure out which method works best for you. Seeing a copy of the final XML is useful, but without a sample of data, to see the structure of the current SAS data set, it is hard to make any constructive suggestions.
Documentation for the XML Libname engine is here: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/engxml/titlepage.htm and an XML Map paper is here: https://support.sas.com/resources/papers/proceedings13/124-2013.pdf that shows the use of an XML Map for both import and export.

Cynthia

topic How to create an xml file from a SAS table in SAS Programming

How to create an xml file from a SAS table

Re: How to create an xml file from a SAS table