Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • -esttab-: Displaying b coefficient and exp(b) coefficient for the same model

    Dear all

    I am fitting a model like this:

    Code:
    sysuse auto, clear
    
    eststo clear
    eststo: logit foreign gear_ratio turn
    
    esttab, b(2) z(2) wide
    and I obtain a table like this:

    Code:
    -----------------------------------------
                          (1)                
                      foreign                
    -----------------------------------------
    foreign                                  
    gear_ratio           4.78***       (3.36)
    turn                -0.38*        (-2.43)
    _cons               -1.70         (-0.24)
    -----------------------------------------
    N                      74                
    -----------------------------------------
    z statistics in parentheses
    * p<0.05, ** p<0.01, *** p<0.001
    Is there a way to have esttab add a third column that contains the exp(b) coefficient?

    I am aware of the eform option of esttab. As far as I understand it, eform allows me to do the entire model in e-form, e.g.

    Code:
    . esttab, b(2) z(2) wide eform
    
    -----------------------------------------
                          (1)                
                      foreign                
    -----------------------------------------
    foreign                                  
    gear_ratio         119.25***       (3.36)
    turn                 0.68*        (-2.43)
    -----------------------------------------
    N                      74                
    -----------------------------------------
    Exponentiated coefficients; z statistics in parentheses
    * p<0.05, ** p<0.01, *** p<0.001
    which however doesn't have the b coefficients.

    Using the eform(0 1) option got me a bit closer to what I want, but I am unhappy about the facts that it now looks like two models, that the z-statistic is printed twice etc.

    Code:
    sysuse auto, clear
    
    eststo clear
    eststo: logit foreign gear_ratio turn
    eststo: logit foreign gear_ratio turn
    
    esttab, b(2) z(2) wide eform(0 1)
    
    ----------------------------------------------------------------------
                          (1)                          (2)                
                      foreign                      foreign                
    ----------------------------------------------------------------------
    foreign                                                               
    gear_ratio           4.78***       (3.36)       119.25***       (3.36)
    turn                -0.38*        (-2.43)         0.68*        (-2.43)
    _cons               -1.70         (-0.24)         0.18         (-0.24)
    ----------------------------------------------------------------------
    N                      74                           74                
    ----------------------------------------------------------------------
    z statistics in parentheses
    * p<0.05, ** p<0.01, *** p<0.001
    Is there any other solution?

    Thanks for your consideration
    Klaus

  • #2
    In case I have to google this again: The answer is:

    Code:
    sysuse auto, clear
    
    eststo clear
    eststo: logit foreign gear_ratio turn
    estadd expb
    
    esttab, cells("b(fmt(2)) z(fmt(2)) expb(fmt(2))")

    Comment

    Working...
    X