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

st: Re: Question: Saving table result


From   Friedrich Huebler <huebler@rocketmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Re: Question: Saving table result
Date   Tue, 17 Feb 2004 15:26:52 -0800 (PST)

--- gte573q@mail.gatech.edu wrote:
> 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
> -----------------------------------------------

Sugie,

If you don't need the first -tabstat- column you can save the
generated values with the help of the -tabstatmat- and -dropmiss-
packages from SSC.

. ssc install tabstatmat
. ssc install dropmiss

Example using the auto data:

. sysuse auto, clear
. tabstat price weight, by(foreign) stats(sum) save
. tabstatmat matvars
. svmat matvars
. keep matvars*
. dropmiss, obs
. outsheet using table.txt

The tab-delimited file table.txt can be opened in Excel.

Question to other list members: How can the first -tabstat- column be
saved together with the other columns?

Friedrich Huebler

__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
*
*   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