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: 1748Registered: 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
 sadya2018@gmail.com Messages: 98Registered: April 2018 Location: Ethiopia, in Africa Senior Member
Thank you all!!

Hassen Ali Hamza (BSc in Public Health,Master of Public Health Candidate)
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: 19Registered: 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
 sadya2018@gmail.com Messages: 98Registered: April 2018 Location: Ethiopia, in 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 Hamza (BSc in Public Health,Master of Public Health Candidate)

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

Report message to a moderator

 Previous Topic: Exact stunting rate with exact observation number Next Topic: Details about KR file
Goto Forum:

Current Time: Mon Feb 17 18:14:38 Eastern Standard Time 2020