Re: st: RE: RE: joinby command and memory issues

[Eric Booth <ebooth@ppri.tamu.edu>]

<>

Thanks for the update -- glad you finally got it to work (even though you had to combine several strategies).
Sounds like you'll be able to avoid this extra work in the future with the new system upgrade.

- Eric
__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
Office: +979.845.6754


On Oct 12, 2010, at 3:27 PM, Weichle, Thomas wrote:

> Ok, I have an update.  I followed the -reshape- approach you suggested.
> I had no problems with reshaping epo.dta.  Then, I tried the merge with
> hgb.dta (which only contained the necessary 3 vars and was compressed).
> However, even this merge became too much for my system to handle.  And
> just to test, I tried joinby with hgb.dta.  Not surprisingly, this
> failed as well.  So, I came to the point of needing to split hgb.dta.  I
> initially split it into 10 separate datasets.  For each of these, I used
> joinby with epo.dta.  This worked smoothly and I saved the joined
> datasets.  Then, I appended all 10 together.  I believe I am finally at
> the point where I wanted to be.  
> 
> Eric and everyone else, thank you very much for your suggestions.  This
> was quite a learning experience.  By the way, I found out that we will
> be upgrading to 64-bit in the near future!
> 
> Tom Weichle
> Math Statistician
> Center for Management of Complex Chronic Care (CMC3)
> Hines VA Hospital, Bldg 1, C202
> 708-202-8387 ext. 24261
> Thomas.Weichle@va.gov 
> 
> 
> *
> *   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/

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