topic Re: problem Importing big XML file 3gb in SAS Programming

problem Importing big XML file 3gb

SA159 — Wed, 11 Jan 2017 14:03:17 GMT

Hello

I have a problem importing a very big XML file on 3gb.

I tried to do it with xml mapper but the file is way to big.

Anyone got a solution to how i can import the whole file without splitting it up ?

Thank in advance.

Re: problem Importing big XML file 3gb

Cynthia_sas — Wed, 11 Jan 2017 15:40:53 GMT

Sometimes you can build the map on a smaller version of the XML file and then use the generated MAP on the big file by running the code outside of the XML Mapper.

cynthia

Re: problem Importing big XML file 3gb

snoopy369 — Wed, 11 Jan 2017 19:26:53 GMT

You don't need to use the XML mapper if you know the XML schema and know how you want to import the data. You can use XSL to create your own map without opening the XML file at all.

Is this a complicated (many fields) XML file, or is it many rows but just a few fields? Or, more importantly, just a few fields you want? If you put more detail (such as an example of the XML file, one "row" or two "rows" worth) you can get a better answer here.