Duplicates in KR file and Empty values for HV005 after merging. [message #15092] |
Fri, 01 June 2018 06:09 ![Go to next message Go to previous message](/theme/default/images/down.png) |
Mayank_Ag
Messages: 22 Registered: May 2018 Location: Hyderabad
|
Member |
|
|
I am using DHS 15-16 for India and doing the analysis in SPSS.
1. While merging PR and KR files i found duplicate values in the KR file with same value for all indicators for the child. Can somebody please explain why is this happening and how to deal with them?
2. Further the merged file is having 3 missing values for HV005 (Household weight). This is after applying the following filters.
a) Child is alive (B5)
b) listed in the household(B16)
c) Removed the duplicates from KR file.
Is there any other filter i need to apply so that these empty values don't come in the final dataset? I have already gone through the previous posts on this forum but couldn't figure out a solution to this problem. Are these 3 cases coming because of the 6 duplicates?
Thanks in advance!!
[Updated on: Fri, 01 June 2018 06:49] Report message to a moderator
|
|
|