Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: How to export a summary statistics table?
From
Yuval Arbel <[email protected]>
To
[email protected]
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 <[email protected]> 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 <[email protected]> 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: [email protected]
>> *
>> * 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: [email protected]
*
* 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/