BookmarkSubscribeRSS Feed
sidello
Calcite | Level 5

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!

 

1 REPLY 1
JosvanderVelden
SAS Super FREQ
I assume the error is in the map file.
Can you share the map file?

Best regards, Jos

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 500 views
  • 0 likes
  • 2 in conversation