Probit marginal effects output table to Word

[Sami Petersen]

Hi,

I'm trying to make a regression table using Probit which reports marginal effects, and which I can put in a Word document such that it looks like journal article tables.

I followed advice from here but when typing outreg2 using results, word it says file results.txt could not be opened.

Is there a way to fix this issue? Or is there an easier way to make such a regression table?


Many thanks.

[Andrew Musau]

outreg2 is from SSC (FAQ Advice #12). You do not show your regression command. Note that the probit coefficients are not marginal effects, so you should use margins with the -post- option to get the marginal effects.

word it says file results.txt could not be opened.

Make sure that the file results.txt is not open, and add the -replace- or -append- option if such a file already exists.

[Sami Petersen]

Thanks! I wrote this:

probit eh5 h3, r
margins, dydx(*) atmeans
outreg2 using results, word

and it said: file results.txt could not be opened

I do not have a file called results.txt because this website wrote that the command I used will generate the file.

What's going wrong here?

[Andrew Musau]

First

ssc install outreg2, replace

Then try

probit eh5 h3, r
margins, dydx(*) atmeans post
outreg2 using results, word replace

[Sami Petersen]

Thanks, but it still says file results.txt could not be opened

[Andrew Musau]

I cannot tell you what the issue is. The following works for me:

webuse lbw, clear
probit low age ui ht i.race
margins, dydx(*) atmeans post
outreg2 using results, word replace

Res.:

. outreg2 using results, word replace
results.rtf
dir : seeout

[Sami Petersen]

Thanks, turns out I was using an online directory - that was the problem

[Hend She]

Andrew Musau Any advice on how to generate a multiple marginal effects table for three regressions ( probit, IV, 2SLS)?

[Andrew Musau]

IV is ambiguous, 2SLS is linear IV regression. For linear models, the coefficients are themselves marginal effects. If using outreg2, you want something like

probit...
margins ..., post
estimates store probit
ivregress 2sls ...
estimates store iv2sls
outreg2 [probit iv2sls] using myfile, replace

Or using estout from SSC

probit...
margins ..., post
estimates store probit
ivregress 2sls ...
estimates store iv2sls
esttab probit iv2sls using myfile, replace

[Hend She]

Andrew Musau Thank you so much! I have used the outreg2 and it worked very well, however the labels are not exported to the word doc the way they are shown in my stata window. The categories of the variables are shown not with their unique labels, is there a way to correct for this? And if there a way to add additionally (Wald test of exogeneity: χ 2 ,ρ12 =Corr(υ1, υ2) ..) to the bottom of the table?

[Andrew Musau]

For the labels, include the -label- option

outreg2 using myfile, label

For including statistics, see

help outreg2

under

9. Adding r( ) e( ) scalars

[Hend She]

Thank you so much! Unfortunately, I have tried different commands used there but still not working to get these, Wald test of exogeneity: χ 2 ,ρ12 =Corr(υ1, υ2)

[Andrew Musau]

Reproducible example? As always, see FAQ Advice #12.

[Hend She]

. outreg2 [probit ivprobit iv2sls] using myfile.doc, label adds("Wald chi2 (`=e(df_m)') ", e(chi2), Prob > chi2) replace

I get

check eret list for the existence of e(chi2)

[Andrew Musau]

Sorry, that does not help. Look at

help probit
help ivprobit
help ivregress 2sls

for examples and describe what statistic you need to output, showing an example. If this does not make sense, please (re)read FAQ Advice #12.