topic Re: XML (Chevell are you there?) question in ODS and Base Reporting

XML (Chevell are you there?) question

deleted_user — Fri, 26 May 2006 14:52:35 GMT

I am trying to convert pdf form data to something useful (read SAS data sets). I am using the batch capabilities under Adobe Acrobat Pro to convert to pages/form to xml.

I've come with something, well I hestitate to use the term new, because it's all new to me, but, well, new...

Each one of these things start off with the following:

<================ start insert ==================>

xmlns:pdf="http://ns.adobe.com/pdf/1.3/">
Adobe Designer 6.0

xmlns:xap="http://ns.adobe.com/xap/1.0/">
2005-09-07T10:16:31-05:00
2005-09-06T14:58:03-05:00
2005-09-06T15:26:56-05:00
Adobe Designer 6.0

xmlns:xapMM="http://ns.adobe.com/xap/1.0/mm/">
uuid:6df01935-27c9-4f55-9188-685f73b9397c
uuid:0b4b1c5f-06f7-4fda-88f7-d13da1540150

xmlns:dc="http://purl.org/dc/elements/1.1/">
xml

<================ end insert ==================>

it then continues with a lot of white space, then a bunch of

stuff. (I'll happily fill in the details if you're interested)

I went through the online XML trying to come up with something, but, hey, here I am, so what does that say?

Does anybody (I repeat, Chevell, are you listening) know how to read this?

And, just to throw a followup, monkey wrench into things - I have over 2000 of these. If possible, I'd like to append them all into one file. Yes/No/Are you crazy?

TIA

Re: XML (Chevell are you there?) question

Eric_SAS — Wed, 31 May 2006 15:09:37 GMT

I'm no expert but you should take a look at the XML mapper and the XML libname engine. - they work together. Mapper tells the engine how to map the xml into the dataset. You will probably have to create your own map.

Re: XML (Chevell are you there?) question

Cynthia_sas — Mon, 05 Jun 2006 14:47:58 GMT

Unless your XML is very "regular", you will need to define an XML Map and use that map with the XML Libname Engine to read your XML into a SAS data set. XML Mapper allows you to define the path through the XML file in order to populate your SAS columns. Information on XML Mapper can be found at:
[pre]
http://support.sas.com/onlinedoc/913/getDoc/en/engxml.hlp/a002484805.htm
[/pre]
if you poke around the site, you will find some examples of using maps to convert XML to SAS dataset format.
cynthia

Re: XML (Chevell are you there?) question

Chevell_sas — Tue, 06 Jun 2006 14:13:13 GMT

The XML Mapper can be downloaded from the Client Side CD of the install, or by contacting Technical Support.

Re: XML (Chevell are you there?) question

deleted_user — Mon, 26 Jun 2006 16:05:47 GMT

Finally got back here.
Thank you all.
Ended up using a somewhat hokey, but effective way.
Adobe has a "create spreadsheet" function that sort of did the job.

I'll look into the mapper when I get a chance.