Date:         Thu, 12 Jun 2008 18:41:21 -0400
Reply-To:     Richard Wright <richard.wright@DARS.STATE.TX.US>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Richard Wright <richard.wright@DARS.STATE.TX.US>
Subject:      Re: Effective ways of Programming in SAS when dealing with large
              database tables

On Thu, 12 Jun 2008 17:29:29 -0400, SUBSCRIBE SAS-L Chandra Gadde
<ddraj2015@GMAIL.COM> wrote:

>1 TERRABYTE SIZE table. I am working on a project that involves joining two
>tabels (one is 2.5 terrabytes and another one is 1 terrabyte). :)
>
>
>On Thu, 12 Jun 2008 14:40:24 -0400, Richard Wright
><richard.wright@DARS.STATE.TX.US> wrote:
>
>>On Thu, 12 Jun 2008 12:10:25 -0400, SUBSCRIBE SAS-L Chandra Gadde
>><ddraj2015@GMAIL.COM> wrote:
>>
>>>All
>>>
>>>I am planning to write a paper in our company on using SAS when dealing
>>>with large database tables. Could you please send me some
>>>information/websites/papers on this topic.
>>>
>>>Thanks.
>>
>>I'm curious - what do you consider large?

Guess that rules out keeping all your datasets in memory, but something
that might help you out is allocate enough buffers - probably a trial and
error process and insuring the buffer size is right.