The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Bangladesh » How to calculate mother's age at most recent birth (last birth) in BDHS 2011
How to calculate mother's age at most recent birth (last birth) in BDHS 2011 Tue, 10 February 2015 11:16
 sam07 Messages: 4Registered: January 2015 Location: India Member
Sir, I am interest to know how to calculate mother's age at most recent birth for Bangladesh DHS data set (2011) in SPSS/STATA
Re: How to calculate mother's age at most recent birth (last birth) in BDHS 2011 [message #3792 is a reply to message #3779] Wed, 11 February 2015 12:06
 Bridgette-DHS Messages: 2277Registered: February 2013 Senior Member
Following is a response from Senior DHS Specialist, Noureddine Abderrahim:

You can use the CMC date of birth of the mother, which you will subtract from the CMC date of birth of the child (B3) divided by 12;

Agec = (V011-B3)/12.

An explanation of the CMC or century month code can be found in the DHS Recode Manual.
Re: How to calculate mother's age at most recent birth (last birth) in BDHS 2011 [message #14795 is a reply to message #3792] Sun, 06 May 2018 09:44
 Hassen Messages: 115Registered: April 2018 Location: Ethiopia,Africa Senior Member
Thank you all!!

Hassen Ali(Chief Public Health Professional Specialist)
Re: How to calculate mother's age at most recent birth (last birth) in BDHS 2011 [message #15093 is a reply to message #3792] Fri, 01 June 2018 07:20
 abpromiti Messages: 20Registered: December 2017 Location: Dhaka Member
hi,
i calculated mothers age at birth by
COMPUTE age1 = B3\$01 - V011.
in spss.
but it gives values in cmc.
i want age1 as
<20yrs
20-29yrs
30-34yrs
>35yrs.
what can i do now?
pls help me.
Re: How to calculate mother's age at most recent birth (last birth) in BDHS 2011 [message #15094 is a reply to message #15093] Fri, 01 June 2018 08:31
 Hassen Messages: 115Registered: April 2018 Location: Ethiopia,Africa Senior Member
Dear user, Maternal age at birth is computed as follow:
Maternal age at birth=(B3-V011)/12
For SPSS user, we have to follow the following steps:
1) Open your SPSS Data set
2)Click Transform
3) Click Compute Variable
4)Write your target variable in the target variable box
5) Write the numeric expression (equation)
=(B3-V011)/12 into the Numeric Expression box.
6) Click "Ok"
#Then to Categorized (Recode) this variable follow the following steps:
1)Click Transform
2)Click recode into Different Variable
3) Choose your target variable and move into input variable box
4) Write the output variable "Name & Label"
5) Click "Change"
6) Click "Old and New values"
7)Click "Range,LOWEST through value:Then write for example 19.999 value into the box to exclude the value "20" Then give the value as you want (for example "1") & add
for Range values,for example 20-29 years
Click "Range" write "20" through"29" Then give value for example "2" Then Add
You can do all by this step. ~Finally Click Continue.
I am a new DHS Forum user,You can search other sources for SPSS and also DHS users & experts may add for you.
With Best Wishes,Hassen

Hassen Ali(Chief Public Health Professional Specialist)

[Updated on: Fri, 01 June 2018 08:35]

Report message to a moderator

Re: How to calculate mother's age at most recent birth (last birth) in BDHS 2011 [message #20045 is a reply to message #3792] Mon, 21 September 2020 22:12
 Samia Aziz Messages: 5Registered: August 2020 Member
I am using BDHS 2014, Can you please guide me on how to generate variable for age of mothers at last birth? I use Stata.
Re: How to calculate mother's age at most recent birth (last birth) in BDHS 2011 [message #20064 is a reply to message #20045] Tue, 22 September 2020 16:20
 Shireen-DHS Messages: 66Registered: August 2020 Location: USA Senior Member
Hello,
As described in the previous posts, you need the variables b3 and v011 to calculate mother's age at birth (if using BR or KR file). Below is the specific Stata code that creates three categories. You can recode to other categories using the same logic. If using the IR file you can use the same code but for the most recent birth b3_01 .

Best,

Shireen
The DHS Program

* mother's age at birth (years)
gen months_age=b3-v011
gen mageb=1 if months_age<20*12
replace mageb=2 if months_age>=20*12 & months_age<35*12
replace mageb=3 if months_age>=35*12
label define mageb 1"<20" 2"20-24" 3"35-49"
label values mageb mageb
 Previous Topic: Estimates on birth registration do not match for wealth index Next Topic: Postnatal Care
Goto Forum:

Current Time: Sun May 16 13:24:19 Coordinated Universal Time 2021