Date: Tue, 24 May 2005 08:57:08 -0600
Reply-To: "Barz, Ken" <Ken.Barz@INTRADO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Barz, Ken" <Ken.Barz@INTRADO.COM>
Subject: Re: Extract Data from CLOB
Content-Type: text/plain; charset="us-ascii"
It's a little less brute than what I had in mind I guess. I was
thinking that SAS would just treat the XML in each data set observation
as a string after it reads it in from the CLOB. However, when I tried
to pass it to a SUBSTR function to "brute force" it in place I got a sax
xml parsing error. So at some level, SAS recognizes that it has XML
there in the data set and not just a plain old string. I was just
hoping to process it straight from the data set without dumping it out
somewhere. (mainly because this data set can get rather lengthy.)
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Howard Schreier <hs AT dc-sug DOT org>
Sent: Monday, May 23, 2005 4:58 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Extract Data from CLOB
You could transcribe the XML to an external file and then process it
through the XML engine. Is that considered brute force?
On Mon, 23 May 2005 14:05:29 -0600, Barz, Ken <Ken.Barz@INTRADO.COM>
wrote:
>I apologize if this is a repeat. I posted on the web and never saw it
>come across on either address I use.
>
>
>
>I can connect with SAS 9.1 to Oracle (via SAS/Access to ODBC) and can
>pull the contents of a CLOB field into a SAS data set. The CLOB field
>contains XML, the contents of which are what I really want. Any idea
of
>how I might extract the XML data into its own data set, preferably
using
>some technique short of the brute force method?
>
>
>
>Thanks
| 
