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

From |
Ana Gabriela Guerrero Serdan <ag_guerreroserdan@yahoo.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: How to calculate mortality ratios |

Date |
Mon, 3 Dec 2007 03:02:44 -0800 (PST) |

Dear Steve, I have two datasets. 1) One dataset has individual information for each individual in the household (individual characteristics) and also hh id, regions,pweights, psu, etc.. 2) However, deaths are in a separate dataset which includes only those individuals that died, it specifies: household id, region, gender, pweights, psu, and the causes of death. I want to calculate mortality ratios for each of the causes of death (e.g. disease, traffic accident) per region. So basically the hh id is the variable to know which individuals died in each household. So I think I need to first joinby both datasets, then calculate the population estimates per region and then mortality ratios? thanks, Gaby --- Steven Joel Hirsch Samuels <sjhsamuels@earthlink.net> wrote: > Gaby, why don't you lay out exactly what your files > are, and what > analysis variables are in them. Do you want to do > 'proportional' > mortality ratios, single mortality rates? Do you > want to test > differences among regions (AI02)? > -Steven > On Dec 2, 2007, at 10:13 AM, Ana Gabriela Guerrero > Serdan wrote: > > > Steve, > > > > thanks. Yes sorry my ratio should have been x/y. > > > > I missed to calculate the total population first > as > > this is in a separate file. I was doing > calculations > > only among those that died from different causes. > > > > So from file 2 I need to calculate my total > > population. I have individual information for each > > household in the survey. Not sure if I should > first > > generate a count variable? > > > > svyset AI06 [pw= expweigh], strata( AI05) > > gen count=_n > > svy: total count, over(AI02) > > > > then use this to calculate the mortality ratio in > file > > 1 as you indicated. > > > > thanks again, > > Gaby > > > > > > --- Steven Joel Hirsch Samuels > > <sjhsamuels@earthlink.net> wrote: > > > >> Gaby: > >> > >> 1. Ratio requires a numerator and denominator: > >> > >> svy: ratio myratio = x/y > >> > >> svy: ratio dead should return an error > message > >> in Stata 10. > >> > >> What are your individual observations? people > with > >> dead indicating > >> status yes/no, or some other unit? If you have > an > >> 'area' as your > >> observation, with 'dead' counting deaths and > 'pop' > >> giving the > >> population total for the area, then > >> > >> svy: ratio (mr= dead/pop) > >> > >> would work. > >> > >> 2. svy: prop death will give proportions dead > and > >> not dead. This > >> will be correct if your analytic unit is person. > >> > >> 3. I suggest that you form new strata by pooling > >> singletons into > >> neighboring regions. > >> > >> -Steven > >> On Dec 2, 2007, at 8:25 AM, Ana Gabriela Guerrero > >> Serdan wrote: > >> > >>> Dear Stata Users, > >>> > >>> I have two related questions: > >>> > >>> 1) Im trying to calcuate mortality ratios for > >>> different sub-populations using survey data. > >>> > >>> Is it very naive from my side to use the > following > >>> commands? > >>> > >>> svyset AI06 [pw= expweigh], strata( AI05) > >>> svy: ratio death, over (Province) > >>> > >>> I also get similar results with prop. > >>> > >>> 2) I dont get any SE because I have strata with > >> one > >>> sampling unit. I see that Stata suggests (as > also > >> some > >>> books) to delete or collapse the strata with one > >>> sampling unit. Do you know what are the > >> implications > >>> for this? Would I need to collapse the strata > >>> according to region? > >>> > >>> > >>> thanks, > >>> Gaby > >>> > >>> > >>> > >>> Gaby Guerrero Serdan > >>> > >>> Deparment of Economics > >>> Royal Holloway, University of London > >>> TW20 OEX > >>> Egham, Surrey > >>> England, UK > >>> > >> > > > http://www.rhul.ac.uk/economics/About-Us/postgrads.html > >>> http://www.flickr.com/photos/49939890@N00/ > >>> > >>> Tel: +44 7912657259 > >>> > >>> > >>> > >>> > >> > > > ______________________________________________________________________ > >> > >>> ______________ > >>> Be a better pen pal. > >>> Text or chat with friends inside Yahoo! Mail. > See > >> how. http:// > >>> overview.mail.yahoo.com/ > >>> * > >>> * 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/ > >> > >> Steven Samuels > >> > >> sjhsamuels@earthlink.net > >> 18 Cantine's Island > >> Saugerties, NY 12477 > >> Phone: 845-246-0774 > >> EFax: 208-498-7441 > >> > >> > >> > >> > >> * > >> * 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/ > >> > > > > > > Gaby Guerrero Serdan > > > > Deparment of Economics > > Royal Holloway, University of London > > TW20 OEX > > Egham, Surrey > > England, UK > > > http://www.rhul.ac.uk/economics/About-Us/postgrads.html > > http://www.flickr.com/photos/49939890@N00/ > > > > Tel: +44 7912657259 > > > > > > > > > ______________________________________________________________________ > > > ______________ > > Get easy, one-click access to your favorites. > > Make Yahoo! your homepage. > > http://www.yahoo.com/r/hs > > * > > * 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/ > > Steven Samuels > > sjhsamuels@earthlink.net > 18 Cantine's Island > === message truncated === Gaby Guerrero Serdan Deparment of Economics Royal Holloway, University of London TW20 OEX Egham, Surrey England, UK http://www.rhul.ac.uk/economics/About-Us/postgrads.html http://www.flickr.com/photos/49939890@N00/ Tel: +44 7912657259 ____________________________________________________________________________________ Get easy, one-click access to your favorites. Make Yahoo! your homepage. http://www.yahoo.com/r/hs * * 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/

**Follow-Ups**:**Re: st: How to calculate mortality ratios***From:*Steven Samuels <sjhsamuels@earthlink.net>

**Re: st: How to calculate mortality ratios***From:*Steven Joel Hirsch Samuels <sjhsamuels@earthlink.net>

**References**:**Re: st: How to calculate mortality ratios***From:*Steven Joel Hirsch Samuels <sjhsamuels@earthlink.net>

- Prev by Date:
**Re: st: Quantal Response Equilibrium with Stata** - Next by Date:
**st: Re: When to impute - and an alternative** - Previous by thread:
**Re: st: How to calculate mortality ratios** - Next by thread:
**Re: st: How to calculate mortality ratios** - Index(es):

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