Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Output to excel


From   Roger Newson <roger.newson@kcl.ac.uk>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Output to excel
Date   Mon, 10 May 2004 13:28:48 +0100

At 21:40 09/05/04 +0700, Huong wrote:

 Dear all,

 Is there any command that I can output tables directly to Excel?
Have you experience with this?
You don't say what kind of tables you want to output. However, if the rows of a table are stored in a dataset (with 1 observation per table row), then Stata can output that dataset using -outsheet- to produce a generic spreadsheet. The first step to a solution might therefore be to output tables to a dataset with 1 observation per table row. Several utilities exist on SSC to do this. For tables of frequencies and percentages, there is the -xcontract- package. For tables of basic summary statistics, there is the -xcollapse- package. For tables of confidence intervals, there is the -parmest- package, whose use (together with other packages) is described in Newson (2003).

I hope this helps.

Roger

References

Newson, R. 2003. Confidence intervals and p-values for delivery to the end user. The Stata Journal 3(3): 245-269. Also downloadable from Roger Newson's website at
http://www.kcl-phs.org.uk/rogernewson.


--
Roger Newson
Lecturer in Medical Statistics
Department of Public Health Sciences
King's College London
5th Floor, Capital House
42 Weston Street
London SE1 3QD
United Kingdom

Tel: 020 7848 6648 International +44 20 7848 6648
Fax: 020 7848 6620 International +44 20 7848 6620
or 020 7848 6605 International +44 20 7848 6605
Email: roger.newson@kcl.ac.uk
Website: http://www.kcl-phs.org.uk/rogernewson

Opinions expressed are those of the author, not the institution.

*
* 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/




© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index