DBMAX_TEXT does the trick; thank you all who helped!
From: Jack Hamilton [mailto:firstname.lastname@example.org]
Sent: Sat 1/24/2009 1:42 AM
To: Pettis, Matthew (Prof II&RS)
Subject: Re: [SAS-L] SAS/ACCESS - Oracle: setting field lengths in SAS datasets returned from passthrough
Does the DBMAX_TEXT option do what you want?
Videtis illam spirare libertatis auram
On Jan 22, 2009, at 8:57 am, Matthew Pettis wrote:
> I have a CLOB coming back from an Oracle passthrough query that is
> in length. How do I specify that my receiving variable in a SAS
> be longer than 1024 characters to accommodate this? By default, I get
> SAS thinking that this is 1024 characters, when it is really a CLOB
> I want to set some large default length on this variable length...