Announcement

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

  • How can I Export Nested Probit Analysis Results to Word document?

    Hi all,

    I ran probit and margin with Stata 14.2 for six different years. I used the esttab command to have all the six years tabulated on one page.

    My Question: How can I export the table of nested results to word document in a well arranged format?
    Thanks

    Here are the commands I used;


    probit emp_stat Urbdummy age agesq yrseduc lincome i.marstat i.popgroup Under5 Maleemployed i.province i.wave if year==1989, robust
    eststo a :margin, dydx(*) predict (pr)
    probit emp_stat Urbdummy age agesq yrseduc lincome i.marstat i.popgroup Under5 Maleemployed i.province i.wave if year==1993, robust
    eststo b: margin, dydx(*) predict (pr)
    probit emp_stat Urbdummy age agesq yrseduc lincome i.marstat i.popgroup Under5 Maleemployed i.province i.wave if year==1997, robust
    eststo c: margin, dydx(*) predict (pr)
    probit emp_stat Urbdummy age agesq yrseduc lincome i.marstat i.popgroup Under5 Maleemployed i.province i.wave if year==2001, robust
    eststo d : margin, dydx(*) predict (pr)
    probit emp_stat Urbdummy age agesq yrseduc lincome i.marstat i.popgroup Under5 Maleemployed i.province i.wave if year==2005, robust
    eststo e : margin, dydx(*) predict (pr)
    probit emp_stat Urbdummy age agesq yrseduc lincome i.marstat i.popgroup Under5 Maleemployed i.province i.wave if year==2009, robust
    eststo f: margin, dydx(*) predict (pr)

    esttab a b c d e f

    Code:
    
    ------------------------------------------------------------------------------------------------------------
                          (1)             (2)             (3)             (4)             (5)             (6)   
                     emp_stat        emp_stat        emp_stat        emp_stat        emp_stat        emp_stat   
    ------------------------------------------------------------------------------------------------------------
    emp_stat                                                                                                    
    Urbdummy           -0.239***       -0.230***       -0.225***      -0.0967***       -0.182***       0.0249   
                      (-7.81)         (-7.07)        (-10.92)         (-5.28)         (-9.82)          (1.27)   
    
    age                 0.133***       0.0967***        0.129***        0.134***        0.103***        0.135***
                      (12.78)          (8.20)         (18.08)         (24.00)         (18.13)         (22.37)   
    
    agesq            -0.00140***    -0.000780***     -0.00117***     -0.00121***    -0.000783***     -0.00125***
                      (-9.60)         (-4.72)        (-11.77)        (-15.70)        (-10.00)        (-15.27)   
    
    yrseduc            0.0170***      -0.0177***     -0.00380          0.0148***       0.0319***       0.0234***
                       (4.56)         (-4.33)         (-1.38)          (6.17)         (13.26)          (8.86)   
    
    lincome            0.0797***        0.130***       0.0992***        0.183***        0.175***        0.185***
                      (14.95)         (23.46)         (30.44)         (67.58)         (68.56)         (70.36)   
    
    1.marstat               0               0               0               0               0               0   
                          (.)             (.)             (.)             (.)             (.)             (.)   
    
    2.marstat           0.177*          0.175*          0.122**        0.0691          0.0612           0.146**
                       (2.50)          (2.14)          (2.61)          (1.76)          (1.59)          (3.20)   
    
    3.marstat           0.166*          0.185**         0.143**       -0.0306         -0.0312          0.0127   
                       (2.48)          (2.73)          (3.09)         (-0.79)         (-0.74)          (0.28)   
    
    4.marstat          -0.238***       -0.109**        -0.142***       -0.196***       -0.144***       -0.114***
                      (-7.32)         (-3.14)         (-6.42)        (-11.66)         (-8.65)         (-6.54)   
    
    1.popgroup              0               0               0               0               0               0   
                          (.)             (.)             (.)             (.)             (.)             (.)   
    
    2.popgroup          0.340***        0.372***        0.378***        0.280***        0.171***        0.182***
                       (7.69)          (6.27)         (10.50)         (10.09)          (6.56)          (5.82)   
    
    3.popgroup          0.642***        0.463***        0.279***        0.353***        0.353***        0.330***
                       (7.87)          (4.07)          (4.26)          (5.83)          (5.64)          (4.94)   
    
    4.popgroup          0.782***        0.841***        0.728***        0.661***        0.499***        0.638***
                      (13.53)         (10.20)         (14.47)         (17.92)         (13.57)         (13.69)   
    
    Under5             -0.163***       -0.247***       -0.266***       -0.227***       -0.198***       -0.215***
                      (-6.17)         (-8.56)        (-14.69)        (-16.29)        (-14.24)        (-14.66)   
    
    Maleemployed       -0.192***       -0.458***       -0.410***       -0.580***       -0.506***       -0.549***
                      (-4.94)        (-11.90)        (-17.68)        (-31.79)        (-28.96)        (-29.48)   
    
    1.province              0               0               0               0               0               0   
                          (.)             (.)             (.)             (.)             (.)             (.)   
    
    2.province         -0.244***       -0.490***       -0.232***       0.0140          0.0260          0.0362   
                      (-4.44)         (-6.85)         (-5.59)          (0.41)          (0.85)          (1.07)   
    
    3.province         -0.430***       -0.217**        -0.330***      -0.0519         -0.0725*          0.111*  
                      (-6.02)         (-2.74)         (-6.83)         (-1.43)         (-2.04)          (2.47)   
    
    4.province          0.105          -0.206**        -0.288***      -0.0851*         -0.219***       -0.116**
                       (1.65)         (-2.78)         (-6.31)         (-2.54)         (-7.12)         (-3.12)   
    
    5.province         -0.171**        -0.190**        -0.165***        0.269***        0.157***        0.261***
                      (-3.01)         (-2.82)         (-3.97)          (8.21)          (5.16)          (7.68)   
    
    6.province       0.000830          -0.288***       -0.293***       -0.110**       -0.0456           0.186***
                       (0.01)         (-3.86)         (-6.51)         (-3.07)         (-1.29)          (4.30)   
    
    7.province        -0.0302          -0.479***       -0.325***       -0.268***       -0.165***       -0.161***
                      (-0.51)         (-6.98)         (-7.81)         (-9.05)         (-6.01)         (-5.39)   
    
    8.province         -0.247***       -0.340***       -0.155***      -0.0813*         -0.103**       0.00220   
                      (-3.73)         (-4.73)         (-3.36)         (-2.38)         (-3.23)          (0.06)   
    
    9.province         -0.399***       -0.449***       -0.304***        0.152***        0.230***        0.333***
                      (-5.68)         (-6.19)         (-6.70)          (3.98)          (6.26)          (8.44)

    Last edited by Olabisi Matthew; 07 Oct 2019, 05:59.

  • #2
    You can use one of the procedures that writes results - outreg2 etc. Alternatively, if you select the output and copy table, you can paste it into word pretty easily.

    Comment


    • #3
      Thank you Phil.

      Comment

      Working...
      X