Merging children to their mothers [message #13991] |
Thu, 01 February 2018 05:36 |
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.
|
|
|