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: 11
Registered: August 2019

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 60 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: Merge PR and KR in wave 3, b16 does not exist
Goto Forum:

Current Time: Sat May 30 02:09:24 Eastern Daylight Time 2020