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>
Organization: http://groups.google.com
Subject:      Re: random sampling by IDs (not observations) from a huge database
Comments: To: sas-l@uga.edu
In-Reply-To:  <1169359401.107746.50910@11g2000cwr.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

forgot the number of IDs:
around 1,000,000


Ross wrote:
> > 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