Bookmark and Share

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]

st: How to export a summary statistics table?


From   Yuval Arbel <[email protected]>
To   statalist <[email protected]>
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: [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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index