Date:         Wed, 4 Jan 2006 13:01:36 -0800
Reply-To:     David L Cassell <davidlcassell@MSN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David L Cassell <davidlcassell@MSN.COM>
Subject:      Re: select distinct id from a big dataset
In-Reply-To:  <200601042024.k04JfT0n010572@malibu.cc.uga.edu>
Content-Type: text/plain; format=flowed

bgjiang@GMAIL.COM wrote back:
>vora:
>
>I delete that data this morning since it's should not suppose to be that
>big
>and other workers complaims about space limits (we share the same server ).
>So I can not try this anymore.

I don't understand.

Are you saying that your data are not really supposed to be 280 Gigs and
there
was a mistake in the build?  Or are you saying that your data really are 280
Gigs
but the company is not ready to face that fact?

If you have the data that make up your 280 Gig data set elsewhere, then
perhaps
you should not even attempt to build a data set, but instead consider using
a
data view.  (Or a SQL view through PROC SQL.)  That could save you a lot of
space.

HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/