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
On Thu, 12 Jun 2008 17:29:29 -0400, SUBSCRIBE SAS-L Chandra Gadde
>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
>>On Thu, 12 Jun 2008 12:10:25 -0400, SUBSCRIBE SAS-L Chandra Gadde
>>>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.
>>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.