How can I generate output in Word for correlation tables in Stata?

Question

I want to create output for my correlation table so that I can use it in Word. The only command I found is mkcorr , which only generates output that I can copy in Excel, but not in Word. I need a Paper-style correlation table (with mean, standard deviation, correlation, and significance icon).

Answer 1

Two things:

First, the mkcorr help mkcorr says that you can create output in Word:

"mkcorr creates a correlation table in a format that is easy to import into a table or word processing document"

Secondly, mkcorr does what you want. It includes means, standard deviation, correlation and significance label (as well as minimum and maximum values).

Here is an example:

 sysuse auto mkcorr price mpg, log(C:\Users\Vista\Desktop\auto.doc) replace means sig cdec(2) mdec(2) 

However, the output in Word needs some manipulation compared to the results in Excel.

Answer 2

You can do this with estout / esttab / estpost after installing it:

 capture ssc install estout sysuse auto estpost correlate price mpg weight esttab using corr.rtf 

This is a fairly simple view, but you can make it much more attractive by looking at some examples here .