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

Re: st: Output to excel


From   "Hoang Thanh Huong" <hhuongneu@cardvn.net>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Output to excel
Date   Mon, 10 May 2004 21:08:19 +0700

Thank you, Roger. I will try

Best,
Huong
----- Original Message -----
From: "Roger Newson" <roger.newson@kcl.ac.uk>
To: <statalist@hsphsun2.harvard.edu>
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: 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/
>
>

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