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

st: RE: RE: Question: Saving table result


From   "Sugie Lee" <sugie.lee@arch.gatech.edu>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: RE: Question: Saving table result
Date   Tue, 17 Feb 2004 13:46:27 -0500

It worked. Thansk! Gabi.
But I still need to seek a convenient way to do this job.
Are there other ways to save the result table in spreadsheet format
immediately after "tabstat command"?
I have another question on "tabstat" command.
I put the option command "save" at the end of "tabstat" command.

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

I believe that the option "save" will save the result of tabstat somewhere.
I don't know where STATA saved the result. And I don't know how I can pull
out the result either?
Do I misunderstand the function of the option "save"?
Any comments would be helpful.
Thanks.
sugie




-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Huiber Gabi
(nat1gxh)
Sent: Tuesday, February 17, 2004 12:51 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: RE: Question: Saving table result


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/

*
*   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