Assuming you have all categorical variables encoded 1,2,3.... you can try this:
gen w=1
gen m=10*educ+sex
svyset [pw=w]
svy:tab Income_group m if medical==2
Correct variable names w and m as appropriate for your dataset or
create them as temporary ones.
Correct svy:tab for version 8 syntax if needed.
Sadly svy:tab does not support supercolumns
Best regards,
Sergiy Radyakin
On 1/25/08, krishanu karmakar <[email protected]> wrote:
> 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/
>
*
* 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/
