Dear Michael:
I think the problem you raise (how to get Stata outputs in Excel or Word
format) is useful in practice. I have been working on this issue for
several months and asked many questions to the Statalist. 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
***********************************************************
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/03/05 4:36 PM >>>
Thank you Nick!
The command outsheet var1 var2 var3 var4 using output_filename, replace
noquote
produced a tab-delimited file which Excel easily parses into columns as
a
spreadsheet, and that pastes easily into Word to make an attractive
table.
At 05:45 AM 1/3/2005, you wrote:
>No and yes. Stata [sic] does not attempt
>to emulate everybody's favourite word processor
>or text processor. However, your question is quite
>a common one and many people have developed
>tips or helper programs.
>
>Searching the Statalist archives using keywords like "Word"
>or "Excel" will yield lots of suggestions.
>
>Nick
>[email protected]
>
>Michael McCulloch
>
> > Hello, I would like to display the contents of two variables,
> > med1 and
> > med0, in a table formatted for a manuscript.
> > I have tried the list command, but this does not include
> > graph options for
> > font, etc., and my tables lose their readability in WORD when
> > formatted in
> > anything other than the courier font.
> >
> > Is there a way to produce publication-ready tables from STATA?
> >
> > . list id med1 med0 if med1!=., noobs separator(0)
> > +-------------------+
> > | id med1 med0 |
> > |-------------------|
> > | 43 10.2 5.3 |
> > | 153 13.2 8.5 |
> > | 232 26 15 |
> > | 274 11 7 |
> > +-------------------+
>
>*
>* 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/
Best wishes,
Michael
________________________________________
Michael McCulloch, LAc, MPH
Doctoral Candidate, Division of Epidemiology
University of California at Berkeley
Research Office:
124 Pine Street
San Anselmo, CA 94960-2674
Tel (415) 407-1357
Fax (415) 485-1065
email [email protected]
URL www.medepi.net/meta
www.pinestreetfoundation.org
*
* 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/
