Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: How to export a summary statistics table?


From   K C Wong <kcwong5@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: How to export a summary statistics table?
Date   Sun, 4 Dec 2011 03:00:56 +0800

Hi Dr Yuval.

This may be helpful in your case, the "estpost" command.

cheers



On Sun, Dec 4, 2011 at 2:52 AM, Yuval Arbel <yuval.arbel@gmail.com> wrote:
>
> Dear Statalist participants,
>
> I would like to export the following summary statistics directly to
> excel or word files::
>
>    Variable |       Obs        Mean    Std. Dev.       Min        Max
> -------------+--------------------------------------------------------
>        year |     15847    2005.352    2.988623       2000       2010
>        area |     15843    2563.583    19648.94          1    1127000
>       units |         0
>   min_price |     15954    568793.7     3127463          0   1.32e+08
>    dev_cost |     13575      891919     3479984          1   2.94e+08
> -------------+--------------------------------------------------------
>     bid_num |      9780    6.569734    8.005465          1         97
>     bid_std |      7243    448162.2     3116165          1   1.39e+08
>     bid_win |      9049     1936451    1.08e+07          2   4.37e+08
>  bid_average |      9778     1309271     6359903          1   2.09e+08
>   jerusalem |     15847     .107402    .3096335          0          1
> -------------+--------------------------------------------------------
>  north_golan |     15847    .2064744    .4047877          0          1
>       haifa |     15847     .121411    .3266146          0          1
>      merkaz |     15847    .2532341    .4348776          0          1
>       south |     15847    .2213668      .41518          0          1
>    tel_aviv |     15847    .0388086    .1931446          0          1
> -------------+--------------------------------------------------------
> judea_sama~a |     15847    .0509876    .2199793          0          1
>  bid_win_low |     11314     1387669     9627889          0   4.37e+08
> bid_win_high |      9049     1936451    1.08e+07          2   4.37e+08
>         min |     15954    .7759183    .4169892          0          1
>
> i tried to use -tabout- command as follows (taken from -ssc-):
>
> . tabout min_price dev_cost bid_num using
> "D:\kingston\nili\statistical_summary_2000_2010.csv",replace oneway
> too many values
> r(134);
>
> but Stata gave me this error, which aparently implies that it tries to
> read each row separately and comes across the limit of 65,536 rows in
> excel 2003.
>
> My question are the following:
>
> Am I using the correct command?
>
> If this is the correct command, how do I shape the command so that it
> exports exactly the statistical summary that appears above?
>
> I would like to thank you in advance for your answers.
>
> Yuval
>
> --
> Dr. Yuval Arbel
> School of Business
> Carmel Academic Center
> 4 Shaar Palmer Street, Haifa, Israel
> e-mail: yuval.arbel@gmail.com
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   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   |   Site index