Duplicates in KR file and Empty values for HV005 after merging. [message #15092] |
Fri, 01 June 2018 06:09 |
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
|
|
|
|
Which variable to use. [message #15116 is a reply to message #15114] |
Tue, 05 June 2018 14:10 |
Mayank_Ag
Messages: 22 Registered: May 2018 Location: Hyderabad
|
Member |
|
|
Thanks a lot for your reply. I merged KR with PR and did not remove the obs with missing HV005. I used it to calculate the estimates as presented in Table 10.1 of the final report. My estimates are matching except for the categorization according to Mother's Nutritional Status. I have tried more than 50 combinations but the estimates are coming out the same. I have attached a image for your reference.
I saw posts in the forums where it was mentioned that HA40 should be used. But with HA40 the number of valid obs is coming out to be 3 only (I don't know how). It was also mentioned in the posts that V445 and HA40 are the same variables but i found that they have different values for the obs. I tried using V445 for the estimates but they didn't match.
I applied all the filters as mentioned in the reports (Pregnancy(V213), Birth within 2 months(V222), Mother Interviewed(V015)). Can you please tell me what i am doing wrong here. Are the filters sufficient and right? Please tell me how to go forward with this.
Thanks in advance.
-
Attachment: BMI.JPG
(Size: 46.47KB, Downloaded 566 times)
[Updated on: Tue, 05 June 2018 14:12] Report message to a moderator
|
|
|
|
|
|