Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: Question: Saving table result


From   "Huiber Gabi (nat1gxh)" <nat1gxh@ups.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: RE: Question: Saving table result
Date   Tue, 17 Feb 2004 12:50:41 -0500

Why don't you just

preserve
collapse (sum) pop7 pop8 pop9 pop0, by(city)
save myfile, replace
outsheet using myfile.txt
restore

The open the tab-delimited myfile.txt with Excel?

Gabi

-----Original Message-----
From: gte573q@mail.gatech.edu [mailto:gte573q@mail.gatech.edu] 
Sent: Tuesday, February 17, 2004 12:27 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: Question: Saving table result


Dear Statalist,

I have a simple question.
I conducted "tabstat"(see below)command for my data.
How can I save the result table as a data file?
I have to import the result table into EXCEL.
Please help me out.
Thanks.
sugie

-----------------------------------------------------
.tabstat pop7 pop8 pop9 pop0, by(city) stats(sum) save

Summary statistics: sum
  by categories of: city

city  |      pop7      pop8      pop9      pop0
------+----------------------------------------
city_A|      8695      8739      7132      9488
city_B|    956612    760833    683461    642044
city_C|    751015    695510    655468    644137
city_D|    346775    433034    484904    567810
------+----------------------------------------
Total |   2063097   1898116   1830965   1863479
-----------------------------------------------




*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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   |   What's new   |   Site index