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

From |
"Sergiy Radyakin" <[email protected]> |

To |
[email protected] |

Subject |
Re: st: -table- command and percentages |

Date |
Fri, 25 Jan 2008 18:09:46 -0500 |

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/

**References**:**st: -table- command and percentages***From:*"krishanu karmakar" <[email protected]>

**Re: st: -table- command and percentages***From:*Richard Goldstein <[email protected]>

**Re: st: -table- command and percentages***From:*"krishanu karmakar" <[email protected]>

- Prev by Date:
**Re: st: -table- command and percentages** - Next by Date:
**st: Penalized MLE** - Previous by thread:
**Re: st: -table- command and percentages** - Next by thread:
**st: Penalized MLE** - Index(es):

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