As long as your table has only 3 dimensions, then -tab3way- might be what you
are looking for. It's on the SSC site.
Phil
Quoting krishanu karmakar <[email protected]>:
> Thank you very much Mr. Goldstein.
>
> Since this gives me column percentages I need to interchange the row
> variable and supercolumn variables but still it gives me much more
> than I hoped for.
>
> I am now wondering whether there is any command (wrapper more likely)
> -tablerow- (I did a -findit tablerow- and alas there is none!). As
> -tablecol- from ssc helps to get column percentages and analogously
> -tablerow- would have helped to get row percentages (hopefully). Does
> any one using Stata have any clue about this?
>
> Regards
>
> Krishanu
>
>
>
>
>
> On Jan 26, 2008 2:57 AM, Richard Goldstein <[email protected]> wrote:
> > you can get column percentages via -tablecol- which can be downloaded
> > from ssc
> >
> > Rich
> >
> > krishanu karmakar wrote:
> > > Dear Stata Users,
> > >
> > > I am creating a few tables from my data. This dataset contains details
> > > of morbidity about some individuals. As an example a few of my
> > > variables of interest are,
> > >
> > > education (a categorical variable with four values (codes) 1,2,3,4
> > > giving the educational qualification of the individual)
> > > sex(coded as 1 = Male, 2= Female)
> > > Income_group (a categorical variable with five values (codes)
> > > 1,2,3,4,5 telling which income quintile the individual belongs to)
> > > ill_30 (whether the individual has been ill in last 30 days or not,
> > > coded as 1 = yes, 2=no)
> > > medical (whether any medical advice taken, coded as 1=yes, 2 = no and
> > > set missing for those individuals who were not ill in last 30 days,
> > > i.e. for whom "ill_30" takes the value 2.
> > >
> > > I have already created some tables using -table-, -tab- and -tab2-.
> > > However, I am facing trouble in the following.
> > > I want to create a table where "Income_group" will be on the rows,
> > > "sex" the column variable and "education" the supercolumn variable.
> > > The tabulation will be over medical==2 i,e, my command should be like
> > >
> > > -table cmd- Income_group sex education if medical==2
> > >
> > > If I use -table- as the -table cmd- then the cell figures are some
> > > statistic as enlisted in the -clist- for -table- (help table). I get
> > > the following table
> > >
>
------------------------------------------------------------------------------------
> > > | education and Sex
> > > | -- Illierate - --- Primary -- -- Secondary -
> > > - Higher Sec -
> > > Income_group | Male Female Male Female Male Female
> > > Male Female
> > >
>
--------------+---------------------------------------------------------------------
> > > Very Poor 20% | 56 70 26 21 10 11
> > > 3
> > > Poor 20% | 60 56 40 27 16 9
> > > 1 4
> > > Middle 20% | 54 40 32 31 32 25
> > > 4 4
> > > Richer 20% | 64 59 47 49 49 35
> > > 11 5
> > > Richest 20% | 45 50 53 46 50 48
> > > 15 16
> > >
>
------------------------------------------------------------------------------------
> > >
> > >
> > > I, however, want them as percentage figures (percentage of all those
> > > for whom medical==2). Since either relative frequency or percentage
> > > does not figure out in -clist- or -table- and -tabulate- or -tab2-
> > > cannot handle supercolumn variables (as far as I know) is there any
> > > other way out? I would sincerely welcome any hint. If this type of
> > > question has already been answered or discussed then even a direction
> > > to that will be welcome.
> > >
> > > I gratefully acknowledge the help of all those who might have an answer.
> > >
> > > Regards
> > >
> > > Krishanu Karmakar
> > > *
> > > * 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/
>
--
Philip Ryan
Professor
Discipline of Public Health
Director, Data Management and Analysis Centre
Associate Dean (IT)
Faculty of Health Sciences
University of Adelaide
5005 South Australia
AUSTRALIA
CRICOS Provider Number 00123M
-----------------------------------------------------------
This email message is intended only for the addressee(s)
and contains information that may be confidential and/or
copyright. If you are not the intended recipient please
notify the sender by reply email and immediately delete
this email. Use, disclosure or reproduction of this email
by anyone other than the intended recipient(s) is strictly
prohibited. No representation is made that this email or
any attachments are free of viruses. Virus scanning is
recommended and is the responsibility of the recipient.
*
* 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/