Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: RE: RE: joinby command and memory issues
From
Austin Nichols <[email protected]>
To
[email protected]
Subject
Re: st: RE: RE: joinby command and memory issues
Date
Fri, 8 Oct 2010 17:20:34 -0400
Thomas <[email protected]> :
You can make the merge easier by making two files of just identifiers
from your two data files, keeping only distinct obs, calling them e.g.
id1 and id2, and doing the -joinby- on those, then saving the result
as e.g. ids.dta. Then -joinby- that to each of your datafiles in
turn, and save as new files data1 and data2, which will be smaller and
easier to merge.
On Fri, Oct 8, 2010 at 1:02 PM, Weichle, Thomas <[email protected]> wrote:
> Sorry for the confusion. I was successful in dropping the other
> variables in epo.dta resulting in 2 variables that remain (study_id,
> receipt date). Then, I tried to join epo.dta with hgb.dta (which is in
> memory) containing 3 variables (study_id, test date, test result).
> After trying the joinby command is where I still received the error
> saying that there is no room to add more observations.
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/