how to output the beta, t statistics and p values in one table simultaneously?

[Fred Lee]

how to output the beta, t statistics and p values in one table simultaneously?
Like this:

[Andrew Musau]

ssc install estout, replace

sysuse auto
eststo m1: regress mpg weight disp
eststo m2: regress mpg weight disp turn
esttab m1 m2, cells("b(fmt(3)) p(fmt(3))" se(fmt(3) par)) ///
collab("Coef. (SE)" "p-value", lhs("Variables")) ///
 nonumbers mlab("Model 1" "Model 2") label

Res.:

. esttab m1 m2, cells("b(fmt(3)) p(fmt(3))" se(fmt(3) par)) ///
> collab("Coef. (SE)" "p-value", lhs("Variables")) ///
>  nonumbers mlab("Model 1" "Model 2") label

------------------------------------------------------------------------
                          Model 1                   Model 2             
Variables              Coef. (SE)      p-value   Coef. (SE)      p-value
------------------------------------------------------------------------
Weight (lbs.)              -0.007        0.000       -0.006        0.000
                          (0.001)                   (0.001)             
Displacement .. in.)        0.005        0.594        0.006        0.574
                          (0.010)                   (0.010)             
Turn Circle (ft.)                                    -0.139        0.442
                                                    (0.179)             
Constant                   40.085        0.000       43.588        0.000
                          (2.020)                   (4.964)             
------------------------------------------------------------------------
Observations                   74                        74             
------------------------------------------------------------------------

[Fred Lee]

ssc install estout, replace

sysuse auto
eststo m1: regress mpg weight disp
eststo m2: regress mpg weight disp turn
esttab m1 m2, cells("b(fmt(3)) p(fmt(3))" se(fmt(3) par)) ///
collab("Coef. (SE)" "p-value", lhs("Variables")) ///
nonumbers mlab("Model 1" "Model 2") label

Res.:

. esttab m1 m2, cells("b(fmt(3)) p(fmt(3))" se(fmt(3) par)) ///
> collab("Coef. (SE)" "p-value", lhs("Variables")) ///
> nonumbers mlab("Model 1" "Model 2") label

------------------------------------------------------------------------
Model 1 Model 2
Variables Coef. (SE) p-value Coef. (SE) p-value
------------------------------------------------------------------------
Weight (lbs.) -0.007 0.000 -0.006 0.000
(0.001) (0.001)
Displacement .. in.) 0.005 0.594 0.006 0.574
(0.010) (0.010)
Turn Circle (ft.) -0.139 0.442
(0.179)
Constant 40.085 0.000 43.588 0.000
(2.020) (4.964)
------------------------------------------------------------------------
Observations 74 74
------------------------------------------------------------------------

Wow, this is amazing! Thanks so much!

[Fred Lee]

@Andrew Musau Can we automatically set this?
Can we set the rtf file to landscape view?

[Andrew Musau]

There is no such option in estout, but you got a workaround in this recent thread: https://www.statalist.org/forums/for...landscape-view

[Fred Lee]

There is no such option in estout, but you got a workaround in this recent thread: https://www.statalist.org/forums/for...landscape-view

Thanks Andrew, in that way, I need to set the prehead option after each esttab, it is a little redundant.

[Andrew Musau]

You could ask Ben Jann to add such an option to estout.

[Fred Lee]

ssc install estout, replace

------------------------------------------------------------------------
Observations 74 74
------------------------------------------------------------------------


[/CODE]

when we use label option, can we replace the Onservations to N?

[Andrew Musau]

esttab, label stats(N)

[Fred Lee]

esttab, label stats(N)

Hi Andrew, if I set

stats(N)

can I set the N to be italic? Thanks!

[Andrew Musau]

In SMCL:

sysuse auto, clear
reg mpg weight, nocons
esttab, label stats(N, label({it}N))

Res.:

. esttab, label stats(N, label({it}N))

------------------------------------
                              (1)  
                     Mileage (m~)  
------------------------------------
Weight (lbs.)             0.00625***
                          (16.10)  
------------------------------------
N                          74  
------------------------------------
t statistics in parentheses
* p<0.05, ** p<0.01, *** p<0.001

Not sure if this exports to other formats. In LaTeX, you specify this as "\emph{N}", not sure what is the equivalent in -rtf- format. Just Google it.

[Fred Lee]

Thank you!

[Andrew Musau]

Actually, this is covered in http://repec.org/bocode/e/estout/esttab.html

[Fred Lee]

This works, thanks a ton!