Dear Tracey:
A few weeks ago, I sent the following e-mail to the StataList concerning
a question related to your concern: how to get Stata ouptut in Excel or
Word? I hope it will help you.
"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".
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://campus.hec.fr/profs/stolowy/perso/home.htm
>>> [email protected] 01/28/05 11:27 AM >>>
> Hi,
>
> I wondered if there was an easy way to extract tables from stata for
> publication. At the moment I create a log file, run my programs, open
the
> log file and scroll through until I find the tables and copy and paste
> them into excel. However, even using the copy table command , this
doesn't
> always work smoothly and I have to reformat. This is fine for the odd
> table but for my current project, I need to produce around 100 tables
for
> publication.
>
> Am I missing something straightforward?
>
> Thanks
> Tracey
>
>
>
_________________________________________________________________
NHS National Services Scotland Disclaimer
The information contained in this message may be confidential or
legally privileged and is intended for the addressee only. If you have
received this message in error or there are any problems please notify
the
originator immediately. The unauthorised use, disclosure, copying or
alteration of this message is strictly forbidden.
_________________________________________________________________
*
* 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/
