Output Publication Style Correlation Table in Stata Using ESTOUT, ESTTAB, ESTPOST

There are two steps involved in outputting the correlation table in word or excel. First we need to run the correlation command with a estpost prefix and then output it in word or excel using the esttab suffix. You can install this command in Stata using ssc install estout.
Download exercise file:
payhip.com/b/0...
Download the code (do and data file) from following link:
thedatahall.co...
Best 10 Introductory Econometrics Books
thedatahall.co...
Econometric Analysis of Cross Section and Panel Data by Jeffrey M. Wooldridge
amzn.to/4220RUA
Introductory Econometrics for Finance by Chris Brooks
amzn.to/3HwmOmM
An Introduction to Modern Econometrics Using Stata by Christopher F. Baum
amzn.to/42prKBT
Microeconometrics Using Stata by A. Colin Cameron and Pravin K. Trivedi
amzn.to/42ra88r
Website: thedatahall.com
Disclaimer: Some links are affiliate links that help the channel at no cost to you.

[@varunmiglani110]

nicely explained

[@bhuyashitalukdar2685]

sir can you please tell me how to change the stars and significance level for the correlation matrix, like if I want only 10, 5 and 1 % sig level?

[@varunmiglani110]

after running the command i get the output in stata window, followed by following lines
(note: file Tables/crop/ACZ.csv not found)
file Tables/crop/ACZ.csv could not be opened
r(603);
---
Results are not saving in excel file.

[@thedatahall]

Which command are you referring to

[@varunmiglani110]

@@thedatahall i run following command estpost tabstat cropdivann cropone grow1-grow17, by(acz) column(statistics)
esttab . using "Tables/crop/ACZ.csv", plain label replace noli main(mean) aux(sd) nostar unstack noobs nonote

[@thedatahall]

The issue is only with the naming part of the command may be u can use esttab using acz.csv etc etc and see if it works

[@varunmiglani110]

resolved: when i run the command esttab . using "Tables/crop.csv"

[@thedatahall]

Then the reason could be that u dint had crop folder

[@varunmiglani110]

@The Data Hall i realised my variables grow1-17 are binary. Hence now wish to get Percentage of each variable. which command can i use in this case. tab1 didnt worked estpost tab1 cropdivann cropone grow1-grow17, by(acz) column(statistics)
esttab . using "Tables/crop1.csv", plain label replace noli main(mean) aux(sd) nostar unstack noobs nonote

[@varunmiglani110]

estpost bysort state_s: tab1 cropdivann cropone grow1-grow17, column
esttab . using "Tables/cropstate.csv", plain label replace

[@thedatahall]

Please share the data at [e-mail] i will check it

[@user-np4si2ks3u]

How could we do this for partial correlation?

[@thedatahall]

What command are u going to use pcorr

[@user-np4si2ks3u]

@@thedatahall Thank you for your quick answer. Yes, I like to do pcorr. I tried "estpost pcorr var1 var2 var3, matrix", but that didnt work.