st: how to integrate xtmixed postestimation results and variances in a table made with esttab

["Marian Bohl" <marian.bohl@ipz.uzh.ch>]

Dear Stata-list Members, 

I have the following problem: 
I have a loop doing several xtmixed regressions and I would like to create
tables, which comprehend not only the number of cases and the log-likelihood
test but also the variance components at country, party and individual level
(random part of the model) and the ICC. When running the analyses the random
part of the model appears in the stata output but I cannot "make it appear"
in the table created by esttab. 

 Furthermore, in the new Stata 12 version the interclass correlation can be
"reached" only by a postestimation command. My question is hence, how can I
export (via esttab) the random part of the model and the ICC directly in my
table. 

Here my syntax. 

foreach var of varlist x1 x2 x3 x4 { 
                xtmixed `var' independent1 independent2  ||country:
||party:, mle variance covar(un) 
                estimates store `var'1 

                estat icc 


                esttab `var'1  using `var'_results.rtf, b(3) se(3) star
onecell obslast eqlabels(none) mtitles ( "`var'" ) /// 
                        title ("`var', preference")  sfmt(2 2 2) /// 
                        scalars(ll  ) 
                        } 

Any help is highly appreciated, 
Flavia

On behalf of a colleague with technical problems
Marian Bohl

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/