Thank you, Roger. I will try it.
Best,
Huong
----- Original Message -----
From: "Roger Newson" <[email protected]>
To: <[email protected]>
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),
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: [email protected]
> 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:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
