03-13-2018 01:12 AM
On Z/OS Mainframe SAS, I was trying to find a way to create an xml file from the SAS dataset created by pulling DB2 data.
However, I was not successful. Please help.
03-13-2018 09:55 AM
03-13-2018 10:20 AM
Here's a simple example using just 3 obs from SASHELP.CLASS:
Here's the tip sheet on using the LIBNAME XML engine: https://support.sas.com/rnd/base/xmlengine/XML94tipsheet.pdf
03-13-2018 04:27 PM
03-14-2018 05:47 AM - edited 03-14-2018 05:48 AM
Your code runs on the server side which happens to be a Mainframe. A path like C:\Users\b869363\Desktop\CVDOUT.xml is certainly not valid on a Mainframe.
03-14-2018 09:34 AM
03-18-2018 11:38 PM
As Cynthia suggested, I did open a track and it helped me generate the XML document even without using an XML schema.
Instead of these 3 statements,
FILENAME OUT 'C:\Users\b869363\Desktop\CVDOUT.xml';
LIBNAME OUT XML92 XMLTYPE=XMLMAP
I had to code this one line.
LIBNAME OUT XMLV2
where LIBNAME is the reserved word, XMLV2 is the engine name and OUT is the DDNAME assigned to the following dataset.
03-18-2018 11:42 PM
Here is the final output.
<?xml version="1.0" ?>