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.
[...]
When you do a match-merge, Stata must prepare for the maximal
possible resulting dataset, which would be the result of a total
mismatch between the two existing datasets. That result would be a
dataset with n1 + n2 observations, where n1 = number of obs in the
master set, and n2 = number of obs in the using set. The width of
this set, which is independent of the degree of matching, is (width
of master) + (width of using) - (width of common variables). So you
can get a very large potential set, even if the actual set is much
smaller (due to matches). (The actual number of observations formed
is n1 + n1 - (number of matched observations) ).