Re: st: Esttab outreg2 questions

[John Luke Gallup <jlgallup@pdx.edu>]

Davila,

I am not familiar enough with the details of -estout-  and -outreg2- to sort this out, but in case it is useful, you can do this easily with -outreg-, another user-written program on SSC.

The following code creates the table below.

sysuse auto, clear
regress mpg length weight, vce(cluster rep78)
outreg, summstat(r2\r2_a\rmse) ctitle("",Cluster)
regress mpg length weight
outreg using xmpl, stat(beta, t_abs) summstat(r2\r2_a\rmse) ctitle("",Beta) merge

                                                                 -----------------------------
                                                                           Cluster    Beta   
                                                                 -----------------------------
                                                                  length    -0.102   -0.306  
                                                                            (2.73)   (1.44)  
                                                                  weight    -0.003   -0.517  
                                                                            (2.63)   (2.43)* 
                                                                  _cons     50.154           
                                                                           (7.44)**          
                                                                  R2         0.66     0.66   
                                                                  R2_A       0.65     0.65   
                                                                  Rmse       3.45     3.41   
                                                                 -----------------------------
                                                                      * p<0.05; ** p<0.01

The table is saved as a Word table rather than in Excel table as in your example, but -outreg- allows pretty complete control over the table formatting including fonts.

John

On Jan 7, 2013, at 5:02 PM, Davia Downey <downeyd@gvsu.edu> wrote:

> Hello all,
> 
> I have a quick question about the outreg2 and esttab packages. I am running a set of regressions; the first using the vce(cluster) function, and the second using the same variables but asking for the beta coefficients. Once I've stored the estimates I want to make a table that has both models side by side. In one I'd like to present the robust standard errors in one column along with r2,  ar2, rsme, and in the second showing the beta in place of the regular coefficients along with ar2, r2, and rsme. When I try to do this using append all I get is the same two tables pasted with the initial command asking for se(4) ar2 rsme instead of two different tables with the separate information presented side by side. 
> 
> I use the Eststo: quietly regress x y1 y2...., vce(cluster) and Eststo: quietly regress x y1 y2..., beta for the second. 
> 
> To call the Esttab, I use esttab: se(4) ar2 rsme beta, append 
> Then I use outreg2 using myfile, excel to save
> 
> I'm new to Stata so any help/advise would be greatly appreciated. 
> 
> 
> Davia Downey
> Assistant Professor
> Department of Public, Nonprofit and Health Administration
> Grand Valley State University
> 
> 
> *
> *   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/


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