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   Yuval Arbel <yuval.arbel@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: How to export a summary statistics table?
Date   Sat, 3 Dec 2011 22:26:00 +0200

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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index