Michael,
I guess your ado file would be very useful to me.
Could you please send the ado file to me or post it to SSC?
(Email: [email protected])
I also appreciate valuable suggestions by Nick and Friedrich.
Thanks.
Sugie
-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of de la Garza,
Adrian
Sent: Wednesday, February 18, 2004 1:53 PM
To: [email protected]
Subject: st: RE: Re: Question: Saving table result
Michael,
I would be very interested.
Thank you,
Adrian
> -----Original Message-----
> From: Michael Blasnik [mailto:[email protected]]
> Sent: Wednesday, February 18, 2004 11:12 AM
> To: [email protected]
> Subject: st: Re: Question: Saving table result
>
>
> I have written an ado that makes this process easier. It
> writes a matrix to
> a tab delimited text file. Instead of using svmat or svmat2
> and dropping
> vars and outsheet and then needing to relaod your data as in
> the example,
> you could just:
>
> tabstat .....save
> tabstatmat matvars
> mat2txt , matrix(matvars) saving(mytable1.txt)
>
> the ado also gives options for a table title and a table note (at the
> bottom) and allows you to replace existing files or append
> onto them as well
> as set the numeric formatting for columns. I can send it to
> interested
> parties and/or post it to SSC if there is interest. It uses the file
> command so it doesn't disturb your current data and works quickly (no
> preserve,restore).
>
> Michael Blasnik
> [email protected]
>
> ----- Original Message -----
> From: "Friedrich Huebler" <[email protected]>
> To: <[email protected]>
> Sent: Tuesday, February 17, 2004 6:26 PM
> Subject: st: Re: Question: Saving table result
>
>
> > --- [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
>
>
> *
> * 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/
