XML import with XMLMAp error

sidello — Fri, 12 Mar 2021 16:52:05 GMT

Dear all,

I would like to import an XML datafile into SAS.

Alongside this .xml file a .map file (XMLMap) was created to allow for correct data structure.

However, when executing the statement we run into an error.

We don't have any clue on where to start looking for the error, i.e. in the XML file or the XMLMap. Could somebody point us to where the error would most likely be? Or even what it actually is telling us?

/*USE XMLMAP AND XMLV2 ENGINE TO IMPORT DOCUMENTS*/

filename out 'E:\data.xml';
filename map 'E:\data.map';
libname out xmlv2 xmlmap=map xmlprocess=permit;

The error:

ERROR: PCDATA content found outside column/table boundary. content is >.

ERROR: Error in the LIBNAME statement.

I cannot share the dataset itself since this data is not allowed to be public yet.

We appreciate any input, advice and guidance!

Re: XML import with XMLMAp error

JosvanderVelden — Fri, 12 Mar 2021 18:17:15 GMT

I assume the error is in the map file.
Can you share the map file?

Best regards, Jos

topic XML import with XMLMAp error in SAS Programming

XML import with XMLMAp error

Re: XML import with XMLMAp error