The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » General Data Questions » date of birth of last child - Rwanda 2005 men's survey
date of birth of last child - Rwanda 2005 men's survey [message #10981] Fri, 14 October 2016 13:29 Go to next message
schoumaker is currently offline  schoumaker
Messages: 65
Registered: May 2013
Location: Belgium
Senior Member
Hello,
In the 2005 Rwanda men's survey datafile (RWMR41FL), I find three variables sm213m sm213y and sm213y related to the "date of the birth of the last child".
I think there is a mistake in the label, because I do not find any question on the date of birth of the last child in the questionnaire (there is one on age at first child), and the distribution of this variable is strange.
Could someone from DHS have a look at these variabkes in the RWMR41FL data file and let me know to which question they correspond ?
Thank you,
Best regards,
Bruno


Bruno Schoumaker
Centre for Demographic Research
Université catholique de Louvain
Re: date of birth of last child - Rwanda 2005 men's survey [message #10999 is a reply to message #10981] Mon, 17 October 2016 11:43 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
Registered: February 2013
Senior Member
The Rwanda file you are referencing (RWMR41FL) is for the 2000 DHS, not 2005.

The variables SM213M and SM213Y are from Q213 in the Male questionnaire (in what month and year was your first child born?)

index.php?t=getfile&id=625&private=0

Please note that for country specific questions, the variables are generally named and coded in the same way as they were on the questionnaire. The variable will have a leading "SH" if the question was asked at the household level, a leading "S" if asked at the women's level, and a leading "SM" if asked at the men's level.
  • Attachment: SM213.jpg
    (Size: 26.76KB, Downloaded 573 times)

[Updated on: Mon, 17 October 2016 14:55]

Report message to a moderator

Re: date of birth of last child - Rwanda 2005 men's survey [message #11003 is a reply to message #10999] Mon, 17 October 2016 14:51 Go to previous messageGo to next message
schoumaker is currently offline  schoumaker
Messages: 65
Registered: May 2013
Location: Belgium
Senior Member
Dear Bridgette - thank you for your reply. You are right, it is the 2000 DHS.

The issue however is that the question 213 is about the birth of the first child; however, the label of the variable for sm213y is "year of birth of the last child". And the distribution of sm213y indeed looks like like the distribution of year of birth of the first child (see tabulation below).

Best regards,

Bruno Schoumaker


. use "C:\12.DATA\DHS\MR\RWMR41FL.DTA", clear

. tab sm213y

year of |
birth of |
last child | Freq. Percent Cum.
-------------+-----------------------------------
1959 | 1 0.07 0.07
1961 | 6 0.44 0.51
1962 | 4 0.29 0.81
1963 | 2 0.15 0.95
1964 | 4 0.29 1.25
1965 | 5 0.37 1.61
1966 | 7 0.51 2.12
1967 | 7 0.51 2.64
1968 | 7 0.51 3.15
1969 | 11 0.81 3.96
1970 | 21 1.54 5.49
1971 | 10 0.73 6.23
1972 | 20 1.47 7.69
1973 | 21 1.54 9.23
1974 | 20 1.47 10.70
1975 | 18 1.32 12.01
1976 | 28 2.05 14.07
1977 | 16 1.17 15.24
1978 | 36 2.64 17.88
1979 | 40 2.93 20.81
1980 | 35 2.56 23.37
1981 | 47 3.44 26.81
1982 | 51 3.74 30.55
1983 | 38 2.78 33.33
1984 | 36 2.64 35.97
1985 | 43 3.15 39.12
1986 | 35 2.56 41.68
1987 | 45 3.30 44.98
1988 | 31 2.27 47.25
1989 | 48 3.52 50.77
1990 | 45 3.30 54.07
1991 | 44 3.22 57.29
1992 | 40 2.93 60.22
1993 | 51 3.74 63.96
1994 | 68 4.98 68.94
1995 | 68 4.98 73.92
1996 | 87 6.37 80.29
1997 | 76 5.57 85.86
1998 | 52 3.81 89.67
1999 | 86 6.30 95.97
2000 | 55 4.03 100.00
-------------+-----------------------------------
Total | 1,365 100.00


Bruno Schoumaker
Centre for Demographic Research
Université catholique de Louvain
Re: date of birth of last child - Rwanda 2005 men's survey [message #11004 is a reply to message #11003] Mon, 17 October 2016 14:57 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
Registered: February 2013
Senior Member
Thanks Bruno. I see your point, and we'll take another look and get back to you.

Re: date of birth of last child - Rwanda 2005 men's survey [message #11010 is a reply to message #11004] Tue, 18 October 2016 09:18 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
Registered: February 2013
Senior Member
Following is a response from Senior DHS Specialists, Tom Pullum & Trevor Croft:

Tom Pullum:

Quote:
Hi Bruno! I wonder how you determined this? I did the following:

set more off
use e:\DHS\DHS_data\IR_files\RWIR41FL.dta, clear

* youngest child has bidx_k==1
* oldest child has bord_k=1

rename b*_0* b*_*

gen first_cmc=.
gen last_cmc=.

local li=1
while `li'<=20 {

replace first_cmc=b3_`li' if bord_`li'==1
replace last_cmc=b3_`li' if bidx_`li'==1

local li=`li'+1
}

gen interval_survey_to_last=v008-last_cmc
gen interval_survey_to_first=v008-first_cmc

tab v201, summarize(interval_survey_to_last) means
tab v201, summarize(interval_survey_to_first) means


use e:\DHS\DHS_data\MR_files\RWMR41FL.dta, clear

gen interval=mv008-sm213c

* Question: is the following closer to the first or second distribution above??
tab mv201, summarize(interval) means

* Answer: much closer to the second. Thus sm213* refer to the first birth, not the last

So--I agree with you that the label should be changed and I will inform Data Processing. I wonder, however, whether the label is what they wanted and the calculation was done wrong. Good catch, as we say--Tom


Trevor Croft:

Quote:
The men's questionnaire refers to the "premier enfant" (first child). The only problem is with the label.

Re: date of birth of last child - Rwanda 2005 men's survey [message #11011 is a reply to message #11010] Tue, 18 October 2016 09:30 Go to previous message
schoumaker is currently offline  schoumaker
Messages: 65
Registered: May 2013
Location: Belgium
Senior Member
Thanks a lot to Trevor and Tom for the responses.
I also think this just a problem with the label, but I wanted to make sure this is the case.
Best regards,
Bruno


Bruno Schoumaker
Centre for Demographic Research
Université catholique de Louvain
Previous Topic: Operationalization v476
Next Topic: defacto and djure variables
Goto Forum:
  


Current Time: Tue Mar 19 00:48:23 Coordinated Universal Time 2024