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/