[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: Output to excel
At 21:40 09/05/04 +0700, Huong wrote:
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).
Is there any command that I can output tables directly to Excel?
Have you experience with this?
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
Lecturer in Medical Statistics
Department of Public Health Sciences
King's College London
5th Floor, Capital House
42 Weston Street
London SE1 3QD
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: