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 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 <[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/