Announcement

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

  • Esttab to word / excel

    Hey,

    I've finished my regressions in stata and am trying to get the output to word using
    Code:
    xtreg MDR i.recession $control , fe 
    eststo m1 
    
    xtreg MDR i.recession $control , re 
    eststo m2
    hausman m1 m2
    esttab m1 m2
    
    sum BDR MDR recession $control
    // en voor BDR
    // BDR altijd FE want significant
    
    xtreg BDR i.recession $control , fe 
    eststo m3 
    
    xtreg BDR i.recession $control , re 
    eststo m4
    hausman m3 m4
    esttab m3 m4
    // capital structure significant positief verandert tijdens recessie met een alfa van < 0.05
    ssc install xttest3, replace
    xtreg MDR i.recession $control , fe
    xttest3
    
    // capital structure significant positief verandert tijdens recessie met een alfa van < 0.05
    xtreg BDR i.recession $control , fe
    xttest3
    
    // heteroskedasticity
    // m5,m6 heteroskadicity present in model, daardoor veranderen de resultaten. Niet langer significant. 
    xtreg MDR i.recession $control , fe vce(robust)
    eststo m5
    xtreg BDR i.recession $control , fe vce(robust)
    eststo m6
    
    esttab m1 m3 m5 m6
    I'm having a hard time copying the code to word as it makes the table look rather bad.
    Code:
     esttab using NAME.rft, m1 m3 m5 m6
    doesn't work either. Does anyone have advice on how to get this output table in word? I'm also trying to get my Hausman test a table of its own to put in my appendix but I could not pull this off either. Some screenshots to clarify:
    7512ff3e328c0ae8454de38001f5c1a3.png becomes fde1c3867ce6c37c0ed5dc9062fd95a2.png

    I plan on renaming some things afterwards. I know that this is not optimal but that is just the way it is for now. I do plan to improve this bad habit in the future though.


    Thanks in advance,
    Jesse
    Attached Files

  • #2
    estout is from the Stata Journal/ SSC.

    esttab using NAME.rft, m1 m3 m5 m6
    You have the order wrong. Should be

    Code:
    esttab m1 m3 m5 m6 using NAME.rft, replace

    Comment

    Working...
    X