The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging children to their mothers
Merging children to their mothers [message #13991] Thu, 01 February 2018 05:36 Go to previous message
tschoudhary is currently offline  tschoudhary
Messages: 7
Registered: January 2018
Member
I am trying to analyse if maternal height is associated with stunting among under five children in the NFHS 4 data set (india using stata). The PR files given me the exact numbers of weighted cases to calculate stunting as per the national report. But it doesn't contain data on the height of children's mothers. this is available in the IR file but i am not able to merge the data for child's haz scores (hc70) with the height of their mothers.

i have tried the following
for the PR file
gen v001 = hv001
gen v002 = hv002
gen v003 = hvidx
sort v001 v002 v003
save as "temp.dta"

use the ir file
sort v001 v002 v003
merge v001 v002 v003 using "temp.dta"

i get additional observations but maternal height isn't linked to the child haz scores (hc70)
tab hc70 if ha3 !=. shows 0 observations.

kindly guide.
 
Read Message
Read Message
Read Message
Previous Topic: NFHS 4 Data (Merging of PR and KR data file)
Next Topic: Merging data from woman (individual) with verbal autopsy
Goto Forum:
  


Current Time: Tue Dec 3 09:13:03 Coordinated Universal Time 2024