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
K C Wong <[email protected]>
To
[email protected]
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 <[email protected]> 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 <[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/
*
* 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/