Thursday, March 09, 2006

st: memory required for -merge-

Danielle H Ferry wrote:

Is there a rule for the amount of memory required for -merge-? I keep getting a "no room to add more variables due to width" error on the same merge. I am attempting to -merge- on only one variable (placefip), and 67% of memory is free before I attempt the -merge- (i.e., while the "master" dataset is loaded). The "using dataset is small, and I've got the memory set quite high (900m). So, I can't understand why I am running into memory problems.

============================================================

If you want to learn about the size of your dataset, you should read this:

http://www.stata.com/support/faqs/data/howbig.html

Before merging, you should also try to -compress- your datasets. One thing I have spotted is the "place_name" variable in your second dataset. According to the information you provide, this is a str39 variable. Do you really need this variable? Isn't it redundant with e.g. "placefip"? If it is, drop it. If it isn't, try to shorten it, by using e.g. abbreviations. Alternatively, you could try to replace it by a numerical value, with (perhaps) value labels.

Hope this helps,

jean * * 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/


Tag:


Links to this post:

Create a Link



<< Home

This page is powered by Blogger. Isn't yours?