Dear Carlo,
Thanks for your suggestion. I will try "compress" but do I need to
increase the memory of the computer? for example, add a 1G memory
stick.
Many thanks.
Natalie
On Sun, Jul 13, 2008 at 2:19 PM, Carlo Lazzaro <[email protected]> wrote:
>
> Dear Natalie,
> I would suggest you to take a look at - help compress -.
>
> HTH and Kind Regards,
>
> Carlo
> -----Messaggio originale-----
> Da: [email protected]
> [mailto:[email protected]] Per conto di natalie chan
> Inviato: domenica 13 luglio 2008 14.27
> A: [email protected]
> Oggetto: st: memory problem when using odbe to read in large dataset
>
> Dear Statalisters,
>
> I am trying to read in a dataset with more than 200 variables and 2
> million observations. the size of the dataset is 2.1G. I am using
> Stata/MP 10 and Ram of the computer I am using is 1G
>
> I set the memory to 500m. the command I used was:
>
> odbc load, table ("firms")
>
> The stata produced the message "obs must be
> between 62593 and 62593. As a possible solution, try increasing memory
> using set memory ".
>
> I increased the memory to 700m, which is the maximum possible memeory
> I can use, but still it did not work.
>
> Could anyone here give some advice? Thanks a lot.
> *
> * 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/
>
*
* 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/
