--- [email protected] 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/
