Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: R: memory problem when using odbe to read in large dataset


From   "Carlo Lazzaro" <[email protected]>
To   <[email protected]>
Subject   st: R: memory problem when using odbe to read in large dataset
Date   Sun, 13 Jul 2008 15:19:34 +0200

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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index