Re: SAS/ACCESS - Oracle: setting field lengths in SAS datasets #2

DBMAX_TEXT does the trick; thank you all who helped!


-----Original Message-----
From: Jack Hamilton [mailto:jfh@stanfordalumni.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?


Jack Hamilton
Videtis illam spirare libertatis auram

On Jan 22, 2009, at 8:57 am, Matthew Pettis wrote:

> Hi,
> I have a CLOB coming back from an Oracle passthrough query that is
> >1024
> in length.  How do I specify that my receiving variable in a SAS
> dataset
> 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
> and
> I want to set some large default length on this variable length...
> Thanks,
> Matt
1/25/2009 11:02:46 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies

Similar Articles

[PageSpeed] 48


Web resources about - Re: SAS/ACCESS - Oracle: setting field lengths in SAS datasets #2 - comp.soft-sys.sas

Data set - Wikipedia, the free encyclopedia
For IBM mainframe term for a file, see Data set (IBM mainframe) . For the telecommunications interface device, see Modem . A dataset (or data ...

Data : Where can I get large datasets open to the public?
Answer (1 of 91): Here's the ones I've found most useful: CrunchBase, US Census, Google Public Data, Infochimps, Timetric, Factual, Freebase, ...

YouTube - Hans Rosling: Let my dataset change your mindset
Hochgeladen am 31.08.2009 http://www.ted.com Talking at the US State Department this summer, Hans Rosling uses his fascinating data-bubble software ...

The Mindset, Skillset, Dataset Approach to Social Media
... Social media is comprised primarily of unstructured data, which is difficult to analyze. A new approach called Mindset, Skillset, Dataset can ...

Sending large datasets to Amazon? Use the Post Office
Amazon has introduced a new method to move large amounts of data to and from …

The Full Dataset on What VCs are Thinking About Funding in 2016
... challenging and many other startups were cutting costs (as many of ours has done in late 2015). We promised that we would clean up the dataset ...

Yahoo Releases the Largest-ever Machine Learning Dataset for Researchers
Yahoo is announcing the public release of the largest-ever machine learning dataset to the research community.

IDG Contributor Network: Are datasets truly anonymized? Two well-suited researchers are going to find ...
With little fanfare or formality, Adam Smith , associate professor of computer science and engineering in Penn State's School of Electrical Engineering ...

House GOP looks to shed light on EPA secret datasets
House Republicans have introduced a bill that would block the Environmental Protection Agency from crafting regulations based on “secret” scientific ...

Guest Contribution: “Capital Control Measures: A New Dataset”
Today we are pleased to present a guest contribution written by Andrés Fernández (IDB), Michael W. Klein (Tufts), Alessandro Rebucci (Johns Hopkins ...

Resources last updated: 3/16/2016 1:01:28 PM