st: RE: Merge : no room to add more variables because of width

[Kieran McCaul <kieran.mccaul@uwa.edu.au>]

...

Type:
help limits

There are limits to both the number of variables and the width of a dataset.  These limits vary depending on which version of Stata you have.



-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of R Zhang
Sent: Monday, 17 February 2014 10:09 AM
To: statalist@hsphsun2.harvard.edu
Subject: st: Merge : no room to add more variables because of width

Dear all,

I have dataset one with 24 million observations, and dataset two with
14,000 observations (12 variables).

I need to do a m:1 merge
master data: dataset one
using : dataset two

my computer ram is 4g,

my merge resutls in an error message"
no room to add more variables because of width
    An attempt was made to add a variable that would have increased the memory required to store an observation beyond what is currently possible.

should I split the data into 2 or 3 small pieces? could you please suggest an efficient way of doing this?

thanks,
Rochelle
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/