Desktop productivity for business analysts and programmers

Import XML variable longer than 32767 charcters

Reply
Occasional Contributor
Posts: 6

Import XML variable longer than 32767 charcters

[ Edited ]

Need to import a hierarchical XML file where one of the tags can contain up to 2,147,483,647 characters. I've created the XML map but not able to import this tag into SAS since its longer than 32767 characters. Can anyone help.

 

I've attached a sample XML and its map.

 

I also have to make some changes to this file and export it back as XML.

 

Thanks.

Attachment
Respected Advisor
Posts: 4,573

Re: Import XML variable longer than 32767 charcters

@cybharg

SAS 9.4 can't deal with such long strings in a single variable. In SAS Viya the new data type VARCHAR can hold up to 2GB but I don't know to what degree the XML engine has already been implemented there.

 

If using a recent SAS9.4 version: You could try and use Python instead; or use Python or any other tool which allows you to deal with such long strings directly without any SAS involvement. 

Occasional Contributor
Posts: 6

Re: Import XML variable longer than 32767 charcters

Thanks Patrick.. I'll try Python..
Regular Contributor
Posts: 150

Re: Import XML variable longer than 32767 charcters

I use C# which has XML at its core. Yes, it runs on Linux too.

 

Look at XDocument which reads it straight in. Also, very good paper at this years SGF on VARCHAR and its support right now in SAS (outside of Viya). Some limitations however.

Ask a Question
Discussion stats
  • 3 replies
  • 166 views
  • 2 likes
  • 3 in conversation