Re: st: Formatted 3-way tables

[Richard Moverare <richard.moverare@gmail.com>]

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/