The SAS XML Mapper cannot import very large files. Somewhere between 30 and 50 meg it stops working (9.4 version). IF your XML file is setup in a way that a subset of the file will include all or most of the tags: <whatever> and closing tags </whatever>. I was able to make a 30 meg text extract (from a 500 meg xml file) - the 1st 30 meg of lines, paying attention to get full tag sets - and closed it with a single extra hand-typed </tag>. Presto, the XML Mapper could parse it and read it and produce the xmlmap. I then used that map to read the entire 500 meg of xml. A few character fields are too short but it is easy to modify the xmlmap and rerun to fix that. I'm not thrilled with the xmlmap - it introduced ordinals that may be unnecessary, but I'm relieved that I could read 500 meg of what will eventually be 9-10 Gig of input XML files. Now I can take the files and reconstruct the desired data. However, if the XML file structure in your huge files cannot be reduced to a small extract, you can't read it in the XML Mapper. An alternative: try the XML handling features of the Groovy language, available via PROC GROOVY (yes, it's a real language and a real SAS PROC).
... View more