Re: st: esttab and xtmixed

[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/