The SAS Output Delivery System and reporting techniques

XML (Chevell are you there?) question

Reply
N/A
Posts: 0

XML (Chevell are you there?) question

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 ==================>









xmlnsSmiley Tonguedf="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
SAS Employee
Posts: 95

Re: XML (Chevell are you there?) question

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.
SAS Super FREQ
Posts: 8,743

Re: XML (Chevell are you there?) question

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
SAS Employee
Posts: 88

Re: XML (Chevell are you there?) question

The XML Mapper can be downloaded from the Client Side CD of the install, or by contacting Technical Support.
N/A
Posts: 0

Re: XML (Chevell are you there?) question

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.
Ask a Question
Discussion stats
  • 4 replies
  • 186 views
  • 0 likes
  • 4 in conversation