[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: Output to excel
Thank you, Roger. I will try it.
----- Original Message -----
From: "Roger Newson" <email@example.com>
Sent: Monday, May 10, 2004 7:28 PM
Subject: Re: st: Output to excel
> 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),
> 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
> Email: firstname.lastname@example.org
> 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/
* For searches and help try: