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 [message #3779] Tue, 10 February 2015 11:16 Go to next message
sam07 is currently offline  sam07
Messages: 4
Registered: 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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2019
Registered: 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 Go to previous messageGo to next message
Hassen
Messages: 111
Registered: 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 Go to previous messageGo to next message
abpromiti is currently offline  abpromiti
Messages: 20
Registered: 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 Go to previous messageGo to next message
Hassen
Messages: 111
Registered: 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.
It may help you!!
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 Go to previous messageGo to next message
Samia Aziz is currently offline  Samia Aziz
Messages: 5
Registered: 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 Go to previous message
Shireen-DHS is currently offline  Shireen-DHS
Messages: 45
Registered: August 2020
Location: USA
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: Mon Nov 23 14:16:22 Coordinated Universal Time 2020