I confirm that -mkcorr- is extremely useful to output a correlation matrix.
Here is an example of syntax:
mkcorr var1 var2 var3, log(correlation) replace num label sig cdec(4)
In the lastest update, there is an important addition: the "casewise" option. Depending on the inclusion of this option or not, the program will use -pwcorr- (default) or -correlate- (with the option).
Best regards
Herv� Stolowy
***********************************************************
Professeur/Professor
Coordinateur du D�partement/Head of Department
HEC Paris
D�partement Comptabilit� Contr�le de gestion / Dept of Accounting and Management Control
1, rue de la Liberation
78351 - Jouy-en-Josas
France
Tel: +33 1 39 67 94 42 - Fax: +33 1 39 67 70 86
[email protected]
http://studies.hec.fr/web/stolowy
>>> [email protected] 01/24 11:26 pm >>>
You may find the mkcorr program (available at SSC archives) useful.
Glenn
Glenn Hoetker
Assistant professor of strategic management
University of Illinois at Urbana-Champaign
[email protected]
217/265-4081
> -----Original Message-----
> From: [email protected] [mailto:owner-
> [email protected]] On Behalf Of Richard Williams
> Sent: Tuesday, January 24, 2006 1:58 PM
> To: [email protected]; [email protected]
> Subject: Re: st: Outputting correlation matrix
>
> At 02:46 PM 1/24/2006, Goerner, Thomas wrote:
> >Dear Listers,
> >
> >I'd like to "outsheet" a correlation matrix from Stata and have in
the
> >past always done so manually (ie. copy&paste into Excel).
> >
> >It seems that -estat vce- will output a correlation or var-covariance
> >matrix into an r()-Matrix. However, I prefer being able to use not
only
> >-corr- but also -pwcorr- and -pcorr- commands none of which seem to
save
> >the entire matrix in r() or e(). These commands seem to retain only
the
> >last or bottom right results
>
> Someday I want to add that to my pcorr2 program. But in the
> meantime, check out estout, estadd and estadd_plus. The latter
> includes a pcorr option; and the help says "The partial correlations
> will be returned in e(pcorr), the semi-partial correlations in
e(spcorr)."
>
>
> -------------------------------------------
> Richard Williams, Notre Dame Dept of Sociology
> OFFICE: (574)631-6668, (574)631-6463
> FAX: (574)288-4373
> HOME: (574)289-5227
> EMAIL: [email protected]
> WWW (personal): http://www.nd.edu/~rwilliam
> WWW (department): http://www.nd.edu/~soc
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
