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: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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