RE: st: table of correlations

[Nick Cox <n.j.cox@durham.ac.uk>]

Also check out -statsby-. 

Nick 
n.j.cox@durham.ac.uk 

Stas Kolenikov

Read on the -post- command, it will do the work for you.

On Fri, Jan 14, 2011 at 4:15 PM, Rodrigo Briceño <rjbriceno@gmail.com> wrote:

> First of all I must clarify that I already try to
> solve this problem using mkcorr.
> I'm using Stata 9.2 and windows XP. I'm applying the following command
> to my data: by isin2, sort : correlate liq1 sap, where isin2 is the
> identification number of each one of my time series. The results I get
> when I apply this command is a list of tables with all the
> correlations asked. What I would like is to collect all the 324
> correlation coefficients to put them on a table, like this (as an
> example):
>
> ISIN2   rho
> 1         0.2356
> 2         0.2541
> 3         0.0123
>
> I was thinking to put each coefficient as a scalar using locals:
>
> local rho1 = r(rho)
> estadd scalar rho1= `rho1'
>
> but I don't know how to call back all the 324 together. If any of you
> know some command or tip that could help me to build this table I will
> appreciate your time.

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/