[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
Tristan Zajonc <tristanz@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: RE: Table Command to Matrix or CSV |

Date |
Sun, 6 Feb 2005 16:25:46 -0500 |

Is there a fast way to get the results of a twoway table with multiple statistics into a matrix format so I can access all the results programmaticly. I'm hoping to create a way to produce a latex table from the table command. Suggestions? I assume there is nothing like this already made (I'm aware of labtabstat outtable etc). Ideally it would produce a latex file with rows and columns plus multiple lines within each cell for each statistic. Tristan On Thu, 3 Feb 2005 16:50:28 -0500, Daniel Egan <dp.egan@gmail.com> wrote: > > > Is there a way to get the results from a table command into a matrix > > > or CSV file? In the end I want in Excel. > > > > > > The command I'm running is: > > > table x y, c(sum z mean z) row col > > > > > > I know there are things like this for reg, tabstat, sum etc but can't > > > find anything for "table" and can't easily replicate the format using > > > other commands. > > 1)a simple-yet-effective-(yet-inefficient) option is to use log2html. > It will require copying and pasting, but the table will be correctly > formated. > > copy and paste (from your browser) the table. It will (usually) paste > as one column. Do Data>Text to Columns>fixed>finish. > > 2) use the -replace- option. This changes the data as -collapse- does, > but is just an option on table. I assume you have a .do file, but > basically: > > ---do file---- > *table 1 > use foo.dta, clear > table table x y, c(sum z mean z) row col replace > outsheet using table1, comma replace > > *table 2 > use foo.dta, clear > table table a b, c(sum z mean z) row col replace > outsheet using table2, comma replace > --------enddo------------- > > Just a matter of taste and particulars... > > The table problem is somewhat interesting, as if I am doing this on > the fly, in Windows when I right click, I have the option of "copy > table", which correctly (via tabs?) delimits the table for pasting in > excel. I have no idea how this works, but I wonder if there is some > shell command to utilize it. > I'm not touching that one however... > > cheers, > > Dan > * > * 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/

**Follow-Ups**:**st: RE: Table Command to Matrix or CSV***From:*Roger Newson <roger.newson@kcl.ac.uk>

**References**:**st: RE: Table Command to Matrix or CSV***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

**Re: st: RE: Table Command to Matrix or CSV***From:*Daniel Egan <dp.egan@gmail.com>

- Prev by Date:
**st: Prcounts** - Next by Date:
**Re: st: RE: Prcounts** - Previous by thread:
**Re: st: RE: Table Command to Matrix or CSV** - Next by thread:
**st: RE: Table Command to Matrix or CSV** - Index(es):

© Copyright 1996–2021 StataCorp LLC | Terms of use | Privacy | Contact us | What's new | Site index |