topic Re: Import XML variable longer than 32767 charcters in SAS Enterprise Guide

Import XML variable longer than 32767 charcters

cybharg — Tue, 08 May 2018 05:50:35 GMT

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.

Re: Import XML variable longer than 32767 charcters

Patrick — Wed, 09 May 2018 03:06:26 GMT

@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.

Re: Import XML variable longer than 32767 charcters

cybharg — Wed, 09 May 2018 05:31:56 GMT

Thanks Patrick.. I'll try Python..

Re: Import XML variable longer than 32767 charcters

AlanC — Sat, 12 May 2018 21:48:13 GMT

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.