topic Using XMLMAP to generate xml from sas data on Mainframe in ODS and Base Reporting

Using XMLMAP to generate xml from sas data on Mainframe

NMcD — Thu, 26 Jan 2012 17:48:15 GMT

I am trying to generate xml using xmlmap on the mainframe.

I generated an xmlmap version 1.9 and using SAS version 9.2.

I can read in the xml without problem using

filename map 'userid.xmlmap';

filename xml_in 'userid.xml';

libname xml_in xml92 xmlmap=map;

proc print displays that the data is there.

I then need to write this data back out as xml using the xmlmap,

I am using the following

filename out 'userid.tempxml';

filename map 'userid.xmlmap';

libname out xml92 xmltype=xmlmap xmlmap=map

data out.xmldata;

set xmldata;

run;

then I get the following from the log and nothing written out

NOTE: Processing XMLMap version 1.9.

NOTE: Libref OUT was successfully assigned as follows:

Engine: XML92

Physical Name: USERID.TEMPXML

ERROR: Relative COLUMN PATH prevents output reconstruction.

ERROR: Internal processing error. Unable to construct DOM

ERROR: ODS Initialization failed.

Any advice would be really appreciated

Thanks

Niall

Using XMLMAP to generate xml from sas data on Mainframe

Cynthia_sas — Thu, 26 Jan 2012 19:33:50 GMT

Hi:

The 9.2 documentation contains this example:

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

I think, given your error messages, especially the "Unable to construct DOM" message that you might need to work with Tech Support on this. (Also, depending on your maintenance release of 9.2, I think that some features of the XML Libname engine were still pre-production -- such as 9.2 M0 versus 9.2 M3).

To send a question to Tech Support, go to http://support.sas.com/ and in the left-hand navigation pane, click on the link entitled "Submit a Problem". Alternately, you can go directly to the Tech Support Problem Form here:

http://support.sas.com/ctx/supportform/createForm

cynthia

Using XMLMAP to generate xml from sas data on Mainframe

NMcD — Mon, 30 Jan 2012 15:54:06 GMT

Thanks - I will follow up with support.

Niall