The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Duplicates in KR file and Empty values for HV005 after merging.
Duplicates in KR file and Empty values for HV005 after merging. [message #15092] Fri, 01 June 2018 06:09 Go to previous message
Mayank_Ag is currently offline  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

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Merging HW to IR for Mali DHS IV - Missing HWCASEID
Next Topic: Appending datasets of one country for several years
Goto Forum:
  


Current Time: Fri Mar 29 10:10:51 Coordinated Universal Time 2024