Take a look at the product which Alan recommended last month:
You can get it, immediately, for a 30 day trial. It might provide exactly
what you are looking for.
Conversely, if the data isn't confidential, I'd be glad to send you (off-
line) the address of someone from SAS who, when I confronted a similar
problem last month, offered to discover why XMLMapper wouldn't do the job
directly. Unfortunately, since I was looking at highly confidential data,
I couldn't take advantage of the offer.
On Fri, 15 Feb 2008 17:42:42 -0500, Jonathan Goldberg
>I am about to get data in XML format, and I want to read it into SAS
>tables using the XML libname engine. The data is large (the XML file for
>one case is 67 pages long).
>I tried to make a map for the libname engine using XMLMapper. It read a
>lot of the data correctly, but not all. One item, toward the end of the
>file, exhibited the following characteristics:
>1) It displayed correctly in the "Full" tab of the XMLMapper main pane.
>2) It displayed incorrectly in the XMLMapper data set view.
>3) It read incorrectly when the mapper-generate map was used with the
>libname engine. The incorrect value was the same as the one in the data
>4) Manually following the path generated by the mapper correctly led to
>5) As a test I tried reading only that item. I got the same (incorrect)
>I have gone through every scrap of material I could find in the SAS help,
>Forum proceedings, and the archives here. I am out of ideas. Anyone have
>For whatever help it might be, I'm running SAS 9.1.3 on Windows XP Pro.
>I'm using XMLMapper version 9.1.0335.20070926.1036 and Sun Java Client VM