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]

st: How to export a summary statistics table?


From   Yuval Arbel <yuval.arbel@gmail.com>
To   statalist <statalist@hsphsun2.harvard.edu>
Subject   st: How to export a summary statistics table?
Date   Sat, 3 Dec 2011 20:52:45 +0200

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/


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