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 at the end of May, 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 04:53:36 +0800

Oh sorry. How about the command below. It should work as you wanted.
logout, save(result) excel word replace: summarize
Openning the result.xml from Excel to get the Excel output. Thanks.


On Sun, Dec 4, 2011 at 4:26 AM, Yuval Arbel <yuval.arbel@gmail.com> wrote:
> Thanks very much for the advice. I tried the following way and it worked partly:
>
> . estpost summ
>
>             |  e(count)   e(sum_w)    e(mean)     e(Var)      e(sd)
>  e(min)     e(max)     e(sum)
> -------------+----------------------------------------------------------------------------------------
>        year |     15847      15847   2005.352   8.931867   2.988623
>    2000       2010   3.18e+07
>        area |     15843      15843   2563.583   3.86e+08   19648.94
>       1    1127000   4.06e+07
>       units |         0          0          .          .          .
>       .          .          0
>   min_price |     15954      15954   568793.7   9.78e+12    3127463
>       0   1.32e+08   9.07e+09
>    dev_cost |     13575      13575     891919   1.21e+13    3479984
>       1   2.94e+08   1.21e+10
>     bid_num |      9780       9780   6.569734   64.08748   8.005465
>       1         97      64252
>     bid_std |      7243       7243   448162.2   9.71e+12    3116165
>       1   1.39e+08   3.25e+09
>     bid_win |     15954      15954    1098342   6.77e+13    8227076
>       0   4.37e+08   1.75e+10
>  bid_average |      9778       9778    1309271   4.04e+13    6359903
>       1   2.09e+08   1.28e+10
>   jerusalem |     15847      15847    .107402   .0958729   .3096335
>       0          1       1702
>  north_golan |     15847      15847   .2064744   .1638531   .4047877
>       0          1       3272
>       haifa |     15847      15847    .121411   .1066771   .3266146
>       0          1       1924
>      merkaz |     15847      15847   .2532341   .1891185   .4348776
>       0          1       4013
>       south |     15847      15847   .2213668   .1723744     .41518
>       0          1       3508
>    tel_aviv |     15847      15847   .0388086   .0373049   .1931446
>       0          1        615
> judea_sama~a |     15847      15847   .0509876   .0483909   .2199793
>       0          1        808
>  bid_win_low |     15954      15954    1247867   6.93e+13    8321924
>       0   4.37e+08   1.99e+10
> bid_win_high |      9049       9049    1936451   1.18e+14   1.08e+07
>       2   4.37e+08   1.75e+10
>         min |     15954      15954   .7759183     .17388   .4169892
>       0          1      12379
>  transaction |     15954      15954   .5671932   .2455005     .49548
>       0          1       9049
>
> . estout using "D:\kingston\nili\statistical_summary_2000_2010.doc",replace
> cells("count mean sd min max")
> (output written to D:\kingston\nili\statistical_summary_2000_2010.doc)
>
> The problem is that the columns in the table did not come out streight
> in the doc file, and the table does not look nice. It looks as if I
> made copy-paste. What I would like to get is something like the output
> of -outreg2- namely, a word table with the summary statistics.
>
> Does anyone have an idea?
>
> On Sat, Dec 3, 2011 at 9:00 PM, K C Wong <kcwong5@gmail.com> wrote:
>> 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/
>
>
>
> --
> 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