Jonathan,

Take a look at the product which Alan recommended last month: http://xrl.us/bgais

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.

Art ------------- On Fri, 15 Feb 2008 17:42:42 -0500, Jonathan Goldberg <jgoldberg@BIOMEDSYS.COM> wrote:

>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 >set view. >4) Manually following the path generated by the mapper correctly led to >the data. >5) As a test I tried reading only that item. I got the same (incorrect) >result. > >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 >any insights? > >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 >1.6.0_0-b06. > >tia