| Discrepancy in resident status between individual files and merged household file [message #24275] |
Mon, 11 April 2022 06:48  |
desktop
Messages: 2
Registered: April 2022
|
Member |
|
|
Hi,
After merging the individual questionnaires with the household member (PR) datasets per Tom Pollum's response in this thread ( https://userforum.dhsprogram.com/index.php?t=msg&th=6693 &start=0&)
, I noticed that the usual versus visiting residents differed between hv102 and (m)v135. See the R code below.
Discrepancies between women (1 = Usual, 2 = Visitor) and merged (PR+IR+MR) dataset (0 = Visitor, 1 = Usual)
table(women$V135, combined$HV102[combined$HV104 == 2], useNA = "ifany")
0 1
1 21537 655926
2 686 21537
Discrepancies between men (1 = Usual, 2 = Visitor) and merged (PR+IR+MR) dataset (0 = Visitor, 1 = Usual)
table(men$MV135, combined$HV102[combined$HV104 == 1], useNA = "ifany")
0 1
1 1884 108320
2 34 1884
Have I missed something, or are these discrepancies due to (m)v135 being reported by the individual themselves and hv102 being reported for all members by one person?
[Updated on: Mon, 11 April 2022 06:58] Report message to a moderator |
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
