Home » Data » Merging data files » Merging Children with Household
| Re: Merging Children with Household [message #9440 is a reply to message #9348] |
Mon, 28 March 2016 14:58   |
 |
user-rhs
Messages: 132
Registered: December 2013
|
Senior Member |
|
|
It could be data entry error too. Six duplicate sets were children who were not listed in the HH roster, although 3 pairs were reported as living with the respondent (Table 1). Seven duplicate pairs were of deceased children--those are straightforward (Table 2). The remaining 13 multiples sets (11 duplicate pairs and 2 triplicate sets) seem highly suspicious (Table 3). For example, check out the first triplicate set (552 149 2 4). You have a 3 living children: a female born 3/2008, a male born 1/2008, and another male born 7/2009. All are singlets. It's highly unlikely to have a child born 1/2008 and another child born 2 months later on 2/2008 (again, both singlets), unless the children were adopted, incorrectly classified as single pregnancies instead of twins, or the woman has a rare condition (e.g. double uterus). Notice also that the MIDX was the same for the female born 3/2008 and the male born 7/2009.
Table 1. Children not listed in household (b16=0)
bysort b5: list v001 v002 v003 b16 b0 b1 b2 b4 b5 b9 midx if count>1 &b16 ==0, sepby(v001 v002 v003) noobs
-> b5 = No
-> b5 = Yes
+-------------------------------------------------------------------------------------------------------------+
| v001 v002 v003 b16 b0 b1 b2 b4 b5 b9 midx |
|-------------------------------------------------------------------------------------------------------------|
| 21 33 2 Not listed in household 1st of multiple 7 2007 Female Yes Lives elsewhere 3 |
| 21 33 2 Not listed in household 2nd of multiple 7 2007 Female Yes Lives elsewhere 2 |
|-------------------------------------------------------------------------------------------------------------|
| 59 40 2 Not listed in household 1st of multiple 3 2012 Male Yes Respondent 2 |
| 59 40 2 Not listed in household 2nd of multiple 3 2012 Male Yes Respondent 1 |
|-------------------------------------------------------------------------------------------------------------|
| 132 14 7 Not listed in household Single birth 6 2008 Male Yes Respondent 3 |
| 132 14 7 Not listed in household Single birth 1 2010 Female Yes Respondent 2 |
|-------------------------------------------------------------------------------------------------------------|
| 447 26 4 Not listed in household 1st of multiple 5 2010 Male Yes Respondent 2 |
| 447 26 4 Not listed in household 2nd of multiple 5 2010 Male Yes Respondent 1 |
|-------------------------------------------------------------------------------------------------------------|
| 478 2 2 Not listed in household Single birth 7 2010 Male Yes Lives elsewhere 2 |
| 478 2 2 Not listed in household Single birth 11 2011 Male Yes Lives elsewhere 1 |
|-------------------------------------------------------------------------------------------------------------|
| 604 73 2 Not listed in household Single birth 4 2008 Female Yes Lives elsewhere 2 |
| 604 73 2 Not listed in household Single birth 11 2009 Male Yes Lives elsewhere 1 |
+-------------------------------------------------------------------------------------------------------------+
Table 2. Deceased children
. bysort b5: list v001 v002 v003 b16 b0 b1 b2 b4 b5 b9 midx if count>1 &b16 !=0, sepby(v001 v002 v003) noobs
-> b5 = No
+----------------------------------------------------------------------------------+
| v001 v002 v003 b16 b0 b1 b2 b4 b5 b9 midx |
|----------------------------------------------------------------------------------|
| 150 23 2 . 1st of multiple 10 2009 Female No . 2 |
| 150 23 2 . 2nd of multiple 10 2009 Female No . 1 |
|----------------------------------------------------------------------------------|
| 269 1 2 . Single birth 5 2007 Female No . 2 |
| 269 1 2 . Single birth 4 2009 Female No . 1 |
|----------------------------------------------------------------------------------|
| 595 44 1 . 1st of multiple 11 2007 Female No . 2 |
| 595 44 1 . 2nd of multiple 11 2007 Female No . 1 |
|----------------------------------------------------------------------------------|
| 613 42 2 . 1st of multiple 10 2011 Male No . 2 |
| 613 42 2 . 2nd of multiple 10 2011 Male No . 1 |
|----------------------------------------------------------------------------------|
| 712 32 2 . 1st of multiple 11 2007 Male No . 3 |
| 712 32 2 . 2nd of multiple 11 2007 Male No . 2 |
|----------------------------------------------------------------------------------|
| 714 44 2 . Single birth 5 2011 Male No . 1 |
| 714 44 2 . Single birth 12 2009 Female No . 2 |
|----------------------------------------------------------------------------------|
| 841 94 4 . Single birth 8 2011 Male No . 2 |
| 841 94 4 . Single birth 8 2012 Female No . 1 |
+----------------------------------------------------------------------------------+
Table 3. Children in household (b16 !=0), with different DOB but same line numbers
-> b5 = Yes
+----------------------------------------------------------------------------------------+
| v001 v002 v003 b16 b0 b1 b2 b4 b5 b9 midx |
|----------------------------------------------------------------------------------------|
| 256 31 2 3 Single birth 11 2009 Male Yes Respondent 1 |
| 256 31 2 3 Single birth 4 2008 Male Yes Respondent 1 |
|----------------------------------------------------------------------------------------|
| 338 44 2 4 Single birth 10 2009 Female Yes Respondent 1 |
| 338 44 2 4 Single birth 12 2008 Male Yes Respondent 1 |
|----------------------------------------------------------------------------------------|
| 345 57 2 4 Single birth 5 2010 Male Yes Respondent 1 |
| 345 57 2 4 Single birth 6 2009 Male Yes Respondent 1 |
|----------------------------------------------------------------------------------------|
| 552 149 2 4 Single birth 3 2008 Female Yes Respondent 1 |
| 552 149 2 4 Single birth 1 2008 Male Yes Respondent 2 |
| 552 149 2 4 Single birth 7 2009 Male Yes Respondent 1 |
|----------------------------------------------------------------------------------------|
| 570 92 2 3 Single birth 7 2008 Male Yes Respondent 2 |
| 570 92 2 3 Single birth 11 2009 Male Yes Respondent 1 |
|----------------------------------------------------------------------------------------|
| 752 14 2 4 Single birth 7 2011 Female Yes Respondent 1 |
| 752 14 2 4 Single birth 12 2008 Male Yes Respondent 1 |
| 752 14 2 4 Single birth 8 2009 Male Yes Respondent 1 |
|----------------------------------------------------------------------------------------|
| 1156 42 2 4 Single birth 11 2011 Male Yes Respondent 1 |
| 1156 42 2 4 Single birth 12 2010 Male Yes Respondent 1 |
|----------------------------------------------------------------------------------------|
| 1164 60 2 3 Single birth 3 2011 Male Yes Respondent 1 |
| 1164 60 2 3 Single birth 12 2011 Female Yes Respondent 1 |
|----------------------------------------------------------------------------------------|
| 1263 132 2 3 Single birth 1 2012 Female Yes Respondent 1 |
| 1263 132 2 3 Single birth 11 2008 Female Yes Respondent 1 |
|----------------------------------------------------------------------------------------|
| 1268 128 2 3 Single birth 6 2009 Female Yes Respondent 1 |
| 1268 128 2 3 Single birth 2 2010 Female Yes Respondent 1 |
|----------------------------------------------------------------------------------------|
| 1273 149 2 4 Single birth 2 2010 Male Yes Respondent 2 |
| 1273 149 2 4 Single birth 6 2008 Male Yes Respondent 1 |
| 1273 149 2 4 Single birth 9 2009 Female Yes Respondent 1 |
|----------------------------------------------------------------------------------------|
| 1315 174 2 3 Single birth 1 2010 Female Yes Respondent 1 |
| 1315 174 2 3 Single birth 7 2008 Female Yes Respondent 2 |
|----------------------------------------------------------------------------------------|
| 1374 26 2 5 Single birth 5 2010 Female Yes Respondent 1 |
| 1374 26 2 5 Single birth 10 2009 Female Yes Respondent 1 |
+----------------------------------------------------------------------------------------+
[Updated on: Tue, 29 March 2016 16:54] Report message to a moderator |
|
|
|
Current Time: Sun Dec 22 11:50:00 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
