topic Create XML file using XSL style sheet in SAS Data Management

Create XML file using XSL style sheet

Halaku — Thu, 09 Feb 2012 20:55:22 GMT

I need to generate XML files from data combined through database tables, I can use Extract transformation to get it. I need to format the XML output according to the XML file format recieved on the other end. Need to know:

1. How to generate XML file.

2. How to use SXL or any other method to format the out put to the required XML format.

I'll appreciate if some details are thrown here.

Misbah.

Create XML file using SML style sheet

BillM_SAS — Fri, 10 Feb 2012 19:23:40 GMT

Have you looked at the XML LIBNAME engine that comes with Base SAS?

http://support.sas.com/documentation/cdl/en/engxml/63177/HTML/default/viewer.htm#titlepage.htm

Create XML file using XSL style sheet

Halaku — Fri, 10 Feb 2012 20:40:16 GMT

I have looked already but is not helpful for what I require. I am intrested in details of how to actually implement the concept, may be a sample job or something.