Re: st: How to calculate mortality ratios

[Steven Samuels <sjhsamuels@earthlink.net>]

Gaby, you didn't answer some of my questions, so I cannot be sure  
this is what you need.  But here are the steps as I see them.   
Substitute your own variable names.  I assume that there is a unique  
person_id, as well as hhid on which to merge the data.

-merge- the two data sets by  hhid and person id (look up -merge- and  
make sure you understand why -joinby- will not work)
The command will look like:
// first do file--create the new data set
use data person
sort hhid person_id
save, replace

use data deaths
sort hhid person_id

merge hhid person_id, using person
tab _merge    // look up -merge- to see how to interpret this
              // there should be no observations with  _merge=1, as  
these are deaths not matched to the person data set
// Assuming 'cause' is a variable which codes cause of death: cause =  
1, 2, 3..
// it is missing for those who have not die
 replace cause=0 if _merge==2  // everybody who did not match a death

svyset psu [pweight=yourweight], stratum(yourstrata)

save new, replace    //Save the data


// second do file   Once you have the new data set up, run your  
survey commands in a separate do file
use new, clear
svy: prop cause, over(region)      //will also give the proportion alive
svy: prop cause, over(region gender)

Good luck!

-Steve

On Dec 3, 2007, at 6:02 AM, Ana Gabriela Guerrero Serdan wrote:


> 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
*
*   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/