| Child growth [message #6942] |
Wed, 05 August 2015 16:15  |
sumonrupop
Messages: 23
Registered: August 2015
Location: Rajshahi
|
Member |
|
|
Hi
i want to calculate intro-uterine growth. For this i need the number of pregnancy with 7+ months duration. But i can not find out which variable belongs to number of pregnancy with 7+ months duration. The frequency of this variable are reported in Table 8.5 in BDHS report.
Also in which way we able to calculate stillirth, neonatal death and perinatal death.
Md. Nuruzzaman Khan
[Updated on: Wed, 05 August 2015 16:16] Report message to a moderator |
|
|
|
| Re: Child growth [message #8433 is a reply to message #6942] |
Tue, 27 October 2015 13:30  |
Trevor-DHS
Messages: 802
Registered: January 2013
|
Senior Member |
|
|
I'm going to give you this in two parts as this is how it is calculated:
1) First using the birth history (Births' recode dataset - BR) calculate the early neonatal mortality.
2) Second using the calendar data from the women's individual recode dataset (IR) calculate the stillbirths.
For the first part you can use the code below:
* Early neonatal mortality
* use Births' Recode
use "BDBR61FL.dta", clear
* create a child Alive or Died variable using the b5 variable
gen alive=b5
lab def alive 0 "Died" 1 "Alive"
lab val alive alive
lab var alive "Alive or Died by the time of survey"
*** Age at death using variables b6 and b5
gen age_death=.
replace age_death = 0 if b6<=106 & b5==0
replace age_death = 1 if b6>=107 & b6<=130 & b5==0
replace age_death = 2 if (b6> 130 & b6<=999) | b5==1
lab def age_death 0 "Early Neonatal Death" 1 "Late Neonatal Death" 2 "Survived Neonatal Period"
lab val age_death age_death
lab var age_death "Neonatal Mortality Status"
gen wt=v005/1000000
svyset v021 [pw=wt], strata(v023)
svy: tab age_death if v008-b3<60, per count form(%7.3g)
svy: tab age_death if v008-b3<60, per col form(%7.3g)
For the second part, open the individual recode dataset (BDIR61FL.dta), and then use the code posted here in this message. In this code, you can ignore births and nlbirths, and just use stillbirths.
These are the two parts that go into table 8.5. The first part will give you 220 early neonatal deaths out of 8789 total births in the period 0-59 months preceding the survey. The second part will give you 232 total stillbirths (223 women with 1 and 4.56 with 2. 223*1 + 4.56*2 = 232).
The perinatal mortality rate is then calculated as (220 + 232) / (8789 + 232) = 0.050 (or 50 per 1000).
In the above code, the first part counts twins, but if you only want pregnancies and not births of 7+ months then you can look at the code for births in the second part, where twins are ignored.
I hope this helps.
|
|
|
|
| Re: Child growth [message #10402 is a reply to message #8433] |
Tue, 26 July 2016 02:21 |
mnisha
Messages: 5
Registered: January 2016
Location: Sydney, Australia
|
Member |
|
|
Hi,
I am working on BDHS data and trying to merge IR and BR datasets in STATA to calculate total number of perinatal deaths. Could you please suggest me the appropriate way to merge IR and BR datasets? I was wondering if the merging will be 1:1 or 1:m?
Thanks in advance.
[Updated on: Tue, 26 July 2016 02:29] Report message to a moderator |
|
|
|
| Re: Child growth [message #10403 is a reply to message #10402] |
Tue, 26 July 2016 02:41 |
sumonrupop
Messages: 23
Registered: August 2015
Location: Rajshahi
|
Member |
|
|
Thank you, here the code you searching. Hope it may work.
////merge birth recode and individual recode/////
clear all
set more off
use "D:\ALL BDHS STATA\BD_2007_DHS_07132015_018_80504\bdbr51dt\BDBR51FL.DTA" , replace
keep caseid v001 v002 v003 //we may put here all required variable
sort v001 v002 v003
//merge with individual recode
merge 1:1 _n using "\ALL BDHS STATA\BD_2007_DHS_07132015_018_80504\bdir51dt\BDIR51FL.DTA"
*keep if _merge==3
drop _merge
Md. Nuruzzaman Khan
[Updated on: Tue, 26 July 2016 02:42] Report message to a moderator |
|
|
|
| Re: Child growth [message #10404 is a reply to message #10403] |
Tue, 26 July 2016 03:44 |
mnisha
Messages: 5
Registered: January 2016
Location: Sydney, Australia
|
Member |
|
|
Thank you so much. I was a bit confused about the merging. I tried 1:1_n merging before. It worked for me as well. But actually I have another problem. My base file is IR dataset. If I use "keep if _merge==3", the number of early neonatal deaths gets decreased from the actual number. So I would like to ask you if my base file is IR dataset and if I want to merge it with BR dataset in order to get the total number of perinatal deaths, is it necessary to drop the unmatched cases in the merged file?
Thanks in advance.
[Updated on: Tue, 26 July 2016 05:22] Report message to a moderator |
|
|
|
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
