The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Child growth
Child growth Wed, 05 August 2015 16:15
 sumonrupop Messages: 23Registered: 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: 800Registered: 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: 5Registered: 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?

[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: 23Registered: 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: 5Registered: 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?

[Updated on: Tue, 26 July 2016 05:22]

Report message to a moderator

Re: Child growth [message #10407 is a reply to message #10404] Tue, 26 July 2016 07:38
 sumonrupop Messages: 23Registered: August 2015 Location: Rajshahi Member
Thank you. I do not think why you use IR file to calculate neonatal mortality?. If you use BR file then you will able to find out the appropriate number without merging. I did this.

However, I also checked merging the IR file and BR file where IR file is the base file. The comment is vice-versa I send you previously.

I think this may work. Otherwise, please fell free to contact me.

Md. Nuruzzaman Khan
Re: Child growth [message #10411 is a reply to message #6942] Tue, 26 July 2016 09:51
 Trevor-DHS Messages: 800Registered: January 2013 Senior Member
There are several other threads on perinatal mortality on the forum. Here is one thread with code for calculating perinatal mortality.
 Previous Topic: Concentration Index Next Topic: Birth interval estimation
Goto Forum:

Current Time: Tue Jul 23 13:08:18 Coordinated Universal Time 2024