export correlationmatrix from stata to excel

[Thomas Hall]

Hello everybody,

I created a correlationmatrix with the following code:

pwcorr roa roe size industry, star(0.1)


Is there a code to convert the matrix into excel where I can still edit it and all rows and columns are in the right position ?

Thanks in advance.
Thomas

[Wouter Wakker]

pwcorr leaves the resulting matrix behind in r(C), albeit without significance stars. You could export this matrix using putexcel.

For example, see https://www.stata.com/stata-news/new...20Excel%20file.

[Thomas Hall]

Thanks for your help.

[Attaullah Shah]

asdoc can export the the correlation table with stars to MS Word (and asdocx can export to Word, Excel or LaTeX). Here is one example:

ssc install asdoc
sysuse auto, clear 
asdoc pwcorr, star(all) replace