On 2/6/08, Ronan Conroy <[email protected]> wrote:
> On 5 Feb 2008, at 16:48, Genty, Celine wrote:
>
> > How can I open a database of 14 Go (11 columns and 186,000,000
> > rows) with Stata/MP 10.0 ?
>
> It may be worth remembering that sample size estimation is the art of
> getting the required amount of precision with the minimum data.
>
> Just because you have that many observations, you may not need them.
Unless the dataset represents banking transactions. In that case you
would really want all of them to be processed! (There was no word on
estimation in the original email)
:)
Sergiy
>
> The existence of only 11 variables also suggests that the number of
> covariate patterns in your data is much less than the number of
> observations so that the dataset might also usefully collapsed.
>
> But you do have a problem in that there's no way to get 14 gigs of
> data into 4 gigs of memory.
>
>
> P Before printing, think about the environment
> =================================
> Ronan Conroy
> [email protected]
> Royal College of Surgeons in Ireland
> Epidemiology Department,
> 120 St Stephen's Green, Dublin 2, Ireland
> +353 (0)1 402 2431
> +353 (0)87 799 97 95
> http://www.flickr.com/photos/ronanconroy/sets/72157601895416740/
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
