# Re: st: How to calculate mortality ratios

 From Ana Gabriela Guerrero Serdan <[email protected]> To [email protected] 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
<[email protected]> 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
> > <[email protected]> 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
> >> 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
> >> 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.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
> >>
> >> [email protected]
> >> 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.flickr.com/photos/49939890@N00/
> >
> > Tel: +44 7912657259
> >
> >
> >
> >
>
______________________________________________________________________
>
> > ______________
> > 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
>
> [email protected]
> 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.flickr.com/photos/49939890@N00/

Tel: +44 7912657259

____________________________________________________________________________________