Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | klrobson@yorku.ca |
| To | statalist@hsphsun2.harvard.edu |
| Subject | Re: st: esttab and xtmixed |
| Date | Mon, 16 Jan 2012 09:05:18 -0500 |
Wonderful! It works! Thank you SO SO much. KR Quoting Carsten Sauer <carsten.sauer@uni-bielefeld.de>: > Hey Karen, > try this example: > > webuse nlswork, clear > eststo: xtmixed ln_w grade age || id: > eststo: xtmixed ln_w grade age || id: grade > eststo: xtmixed ln_w grade age || id: grade age > esttab, wide se transform(#*: exp(@) exp(@)) equations(2:3:4, .:2:2 , > .:.:3, 3:4:5) stardrop(#*:) > > Best, Carsten > > > Am 16.01.2012 03:56, schrieb klrobson@yorku.ca: > > Thanks for this reply. I've been trying this for hours and apologies if I'm > > sounding rather dense, but I just can't crack it. The first model is a null > > model, the second adds a random intercept and the third adds a random > slope. > > > > > > > > Unaltered (apart from the log transformations), my table comes up like this > > after > > esttab eq* ,se nostar transform(ln*: exp(@)^2 exp(@)^2 at*: tanh(@) > > (1-tanh(@)^2)) > > > > > > --------------------------------------------------- > > (1) (2) (3) > > standardre~g standardre~g standardre~g > > --------------------------------------------------- > > standardre~g > > centescs 0.344 0.344 > > (0.0100) (0.0100) > > > > female 0.404 0.402 > > (0.0154) (0.0179) > > > > _cons -0.0272 -0.203 -0.204 > > (0.0291) (0.0247) (0.0260) > > --------------------------------------------------- > > lns1_1_1 > > _cons 0.280 0.177 0.0255 > > (0.0117) (0.00789) (0.00400) > > --------------------------------------------------- > > lnsig_e > > _cons 0.756 0.663 0.658 > > (0.00455) (0.00402) (0.00404) > > --------------------------------------------------- > > lns1_1_2 > > _cons 0.198 > > (0.00959) > > --------------------------------------------------- > > atr1_1_1_2 > > _cons -0.441 > > (0.110) > > --------------------------------------------------- > > N 14170 13995 13995 > > --------------------------------------------------- > > > > > > > > What I want is for the 0.025 and the 0.198 in the last column to switch > places. > > 0.198 is the random slope but is called lns1_1_2_cons in the third > estimation > > because this is how xtmixed automatically orders the output. The > var(constant) > > has been pushed down two rows in the third column due to this naming > > convention. > > > > I know at this rate I'd be better off to just copy and paste, but this has > been > > bugging me for some time and I won't rest til it is solved... > > > > Please estout gurus, spell it out for me in painful detail. I'm weary from > > frustration. > > > > Karen > > > > > > > > > > Quoting Carsten Sauer<carsten.sauer@uni-bielefeld.de>: > > > >> You could use the equations option which is described in help estout > >> (and can be used with esttab). > >> Use the transform option like - transform(#*: exp(@) exp(@)) - to unlog > >> variances. > >> > >> Carsten > >> > >> > >> > >> Am 15.01.2012 03:17, schrieb klrobson@yorku.ca: > >>> Dear Statalist > >>> > >>> I am having what seems like a simple problem that I cannot solve. I have > >>> multiple xtmixed estimations that I want to present in the same table. > >>> > >>> > >>> xtmixed y x1 x2 || id:, mle > >>> estimates store a1 > >>> xtmixed y x1 x2 || id: x1, covariance (unstructured), mle > >>> estimates store a2 > >>> xtmixed y x1 x2 || id: x1 x2, covariance (unstructured), mle > >>> estimates store a3 > >>> esttab a* > >>> > >>> The problem is that in the random coefficient models, the ordering of the > >>> lns1_1_1 changes meaning/order once random intercepts are added to the > >> model. > >>> In the first model lns1_1_1 is the random intercept variance, but in the > >> second > >>> model, it is the random slope variance for x1. Plus variance parameters > >> need to > >>> be "unlogged". > >>> > >>> I know how to create tables separately for the different estimations, but > I > >> just > >>> want to create one giant table in one fell swoop where all the parameters > >> are on > >>> the right lines. I've messed around with scalars and macros but it seems > >> like > >>> there must be something easier that I've overlooked. > >>> > >>> Any help greatly appreciated. > >>> > >>> KR > >>> > >>> > >>> ----- End forwarded message ----- > >>> > >>> > >>> * > >>> * 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/ > >> -- > >> > >> Carsten Sauer > >> SFB 882 "Von Heterogenitäten zu Ungleichheiten" > >> Teilprojekt A6 "Die Legitimation von Ungleichheiten - Strukturelle > >> Bedingungen von Gerechtigkeitseinstellungen" > >> Fakultät für Soziologie > >> Universität Bielefeld > >> Postfach 10 01 31 > >> 33501 Bielefeld > >> Tel.: 0521 106-67291/-6948 (Sekr. Frau Fischer) > >> Fax: 0521 106-6479 > >> > >> * > >> * 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/ > > -- > > Carsten Sauer > SFB 882 "Von Heterogenitäten zu Ungleichheiten" > Teilprojekt A6 "Die Legitimation von Ungleichheiten - Strukturelle > Bedingungen von Gerechtigkeitseinstellungen" > Fakultät für Soziologie > Universität Bielefeld > Postfach 10 01 31 > 33501 Bielefeld > Tel.: 0521 106-67291/-6948 (Sekr. Frau Fischer) > Fax: 0521 106-6479 > > * > * 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/