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
marian is currently offline  marian
Messages: 6
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 7 times)

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

Report message to a moderator

Previous Topic: Merge NFHS 4 recode files
Next Topic: MERGING PR and IR data
Goto Forum:
  


Current Time: Mon Oct 14 22:16:55 Eastern Daylight Time 2019