The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Mismatch between reported and generated output on merged file
Mismatch between reported and generated output on merged file [message #18177] Sat, 05 October 2019 05:58 Go to previous message
marian is currently offline  marian
Messages: 13
Registered: August 2019
Member
Hi,

I have merged two recode files--IR with PR and wanted to check nutritional status across mothers' low BMI (BMI<18.5) but I am not getting the same results as reported in state reports of NFHS 4. I have used the same filters that would have been used for each variable in their respective individual recode files (PR, IR) for NFHS 4.

Eg for Assam, I am getting stunted children of underweight mothers as 42.8% instead of 43.1 and underweight children as 39.9% instead of 40.1%. Also when I had merged the two datasets, only 30% of observations merged. The weighted sample size of state when BMI (tab v445) was checked on this dataset is 32639

Please suggest where the problem lies. I have attached the code.

  • Attachment: IR Merge.txt
    (Size: 1.04KB, Downloaded 348 times)

[Updated on: Sat, 05 October 2019 06:04]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Previous Topic: merging Household members to women file
Next Topic: Merging IR and PR data files
Goto Forum:
  


Current Time: Fri Mar 29 04:13:37 Coordinated Universal Time 2024