Correlation by group - Presented as a matrix?

[Francois Durant]

Hi,

I would like to report correlation between 2 variables in a matrix or any way that would be easy to copy/paste or import in an Excel file. I have a large number of groups so the output I get from Stata is hard to use. Here is the code I have so far:

sysuse auto, clear

sort rep78
by rep78: pwcorr price weight

Can someone help me with that? Thanks in advance!

[Clyde Schechter]

Try this:

clear*
sysuse auto

capture program drop mycorr
program define mycorr
    corr price weight
    gen rho = r(rho)
    keep rep78 rho
    keep in 1
    exit
end

runby mycorr, by(rep78)

list, noobs clean

Instead of the -list- command at the end, use -export excel- and you're done.

-runby-, written by Robert Picard and me, is available from SSC.