Dear Claude:
You raise a tricky issue which has been debated in the Statalist. I copy below a posting I made some time ago (http://www.stata.com/statalist/archive/2005-01/msg00644.html). In summary, there is not a single solution but several ones, depending on the kind of test you perform.
"Thanks to the help of Nick Cox, Kit Baum, Ben Jann (especially for
-estout-) and Ian
Waston (especially for -tabout-), I could make the following
suggestions:
- summary statistics: use -makematrix- with -summarize-, followed by
-mat2txt-.
- you can add a normality test (with -sktest-) with -makematrix-
- univariate test (t test): -statsmat- (if you want some summary
statistics in the same table), -makematrix- with -ttest-, followed by
-mat2txt-
- univariate test (Mann Whitney U test): same procedure with -ranksum-
instead of -ttest-
- univariate test (Chi 2): -tabulate- followed by -tabout-
- correlations: -mkcorr- (and not -pwcorr-)
- factor analysis: -factor- followed by -makematrix- followed by
-mat2txt-
- regression: -estout- (with -estimates store- and -estadd- if you want
to add some specific stats).
Of course, the above suggestions will not cover all the cases. At least,
I know that they work for some research I did in financial accounting.
All the help files will explain how to use the commands".
This was my previous posting. In the meantime, I also found a solution for a Kruskal Wallis test and a cross-tabulation with three variables.
Don't hesitate to contact me again if you need more explanation.
Best regards
Herv� Stolowy
***********************************************************
Professeur/Professor
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
mail: stolowy at hec dot fr
web: http://studies.hec.fr/web/stolowy
>>> [email protected] 30/12/06 1:45 >>>
Claude, I think the best option is the tabout command, type :
ssc describe tabout
Tim
On 12/28/06, Claude Francoeur <[email protected]> wrote:
> Hello,
>
> What is the best way to export Stata results that are presented in a table
> to either Excel or Word?
>
> I use copy table and paste, but it does not always copy properly?
>
> Thanks,
>
> Claude
> *
> * 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/
