Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Richard Moverare <richard.moverare@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Formatted 3-way tables |

Date |
Tue, 27 Mar 2012 09:52:01 +0200 |

Eric, David, thank you for your replies! Both -tab3way- and -tablecol- seem to be doing what I want to do. But it seems a bit difficult to use -logout- in order to get a result that doesn't need further editing. Thanks also for the information about using loops in -tabout-, I don't understand how I didn't see that. However, as I understand it, it is not a solution if you want supercolumns, only when you add more row, or do I miss something here? Anyway, I will make something work by using your suggestions. Still, I am surprised that Stata, that in my opinion is superior to other statistical softwares in most aspects, doesn't have some more elaborate feature for building and exporting tables. In this aspect, SAS, SPSS and other competitors are much better. All the best, Richard 2012/3/26 David Radwin <dradwin@mprinc.com> > > Rick, > > You might also consider Nick Winter's -tablecol- from SSC in conjunction > with the suggestions below. > > David > -- > David Radwin > Research Associate > MPR Associates, Inc. > 2150 Shattuck Ave., Suite 800 > Berkeley, CA 94704 > Phone: 510-849-4942 > Fax: 510-849-0794 > > www.mprinc.com > > > -----Original Message----- > > From: owner-statalist@hsphsun2.harvard.edu [mailto:owner- > > statalist@hsphsun2.harvard.edu] On Behalf Of Eric Booth > > Sent: Monday, March 26, 2012 7:04 AM > > To: statalist@hsphsun2.harvard.edu > > Subject: Re: st: Formatted 3-way tables > > > > <> > > > > Hi Rick: > > > > > > > But I would like column percentages, a "total" column (i.e. smokes yes > > > or no, regardless of race). > > > > > > Take a look at -tab3way- it has the total and percentage options you > > describe. > > > > Also, in terms of exporting these tables (like -tabout- does) you could > > also: > > a) use -contract- to build your tables and then export it using - > > outsheet- or -export excel- > > OR > > b) use -logout- to directly export a -table- or -tab3way- command. > > > > (-logout-, -tabout-, and -tab3way- are from SSC) > > > > > I have looked in the manual for -tabout- > > > but I haven't seen any solution there. I understand that I can > > > generate new variables that give all categories and then use > > > -tabulate-, but I have to generate a great number of tables so it > > > isn't a feasible way. > > > > You should look into -forvalues- or -foreach- looping because it can > make > > the process of creating the combined variable (btw, I suggest using > -egen- > > function -group()- for this) and many N-way -tabout- tables very > > feasible. One way to approach this process is already spelled out on > > pages 35/37 of Watson's -tabout- guide: > > http://www.ianwatson.com.au/stata/tabout_tutorial.pdf > > > > > > - Eric > > > > __ > > Eric A. Booth > > Public Policy Research Institute > > Texas A&M University > > ebooth@ppri.tamu.edu > > Office: +979.845.6754 > > > > > > On Mar 26, 2012, at 3:46 AM, Richard Moverare wrote: > > > > > Dear Statalist, > > > > > > I guess this could be solved in some neat way, but I haven't found > > > anysolution. I would like to create 3-way tables that looks something > > > like: > > > > > > webuse byssin > > > table workplace smokes race, row > > > > > > But I would like column percentages, a "total" column (i.e. smokes yes > > > or no, regardless of race). I have looked in the manual for -tabout- > > > but I haven't seen any solution there. I understand that I can > > > generate new variables that give all categories and then use > > > -tabulate-, but I have to generate a great number of tables so it > > > isn't a feasible way. This is such a basic feature in all other > > > statistical softwares, so I assume there is some easy solution I > > > haven't found. Any help would be greatly appreciated. > > > > > > All the best, > > > Rick M. > > > * > > > * For searches and help try: > > > * http://www.stata.com/help.cgi?search > > > * http://www.stata.com/support/statalist/faq > > > * http://www.ats.ucla.edu/stat/stata/ > > > > > > * > > * For searches and help try: > > * http://www.stata.com/help.cgi?search > > * http://www.stata.com/support/statalist/faq > > * http://www.ats.ucla.edu/stat/stata/ > * > * For searches and help try: > * http://www.stata.com/help.cgi?search > * http://www.stata.com/support/statalist/faq > * http://www.ats.ucla.edu/stat/stata/ * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/

**Follow-Ups**:**Re: st: Formatted 3-way tables***From:*Eric Booth <eric.a.booth@gmail.com>

**RE: st: Formatted 3-way tables***From:*"David Radwin" <dradwin@mprinc.com>

**References**:**st: Formatted 3-way tables***From:*Richard Moverare <richard.moverare@gmail.com>

**Re: st: Formatted 3-way tables***From:*Eric Booth <eric.a.booth@gmail.com>

**RE: st: Formatted 3-way tables***From:*"David Radwin" <dradwin@mprinc.com>

- Prev by Date:
**Re: st: How to find extreme values** - Next by Date:
**st: nlsur quaids** - Previous by thread:
**RE: st: Formatted 3-way tables** - Next by thread:
**RE: st: Formatted 3-way tables** - Index(es):