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

Re: st: Output to excel

From   Roger Newson <>
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.



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

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

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

* For searches and help try:

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