Date: Sat, 20 Jan 2007 22:11:14 -0800
Reply-To: Ross <fed.rossi@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ross <fed.rossi@GMAIL.COM>
Subject: Re: random sampling by IDs (not observations) from a huge database
Content-Type: text/plain; charset="us-ascii"
forgot the number of IDs:
> > How many observations are in your database?
> around 200,000,000
> > How many IDs? I take it that the data are not already sorted by
> > ID. Is that correct? How many IDs do you really want to extract?
> > You state 10 above, but my guess is that might just be a stand-in
> > number for what you are really after.
> it is sorted by date.
> I still need to decide the number of ID I will extract, but it will be
> high. Say 100,000.
> Thanks everyone for your help
> > ____________________________________________________________________________________
> > Don't get soaked. Take a quick peak at the forecast
> > with the Yahoo! Search weather shortcut.
> > http://tools.search.yahoo.com/shortcuts/#loc_weather