Merging Height and Weight Data with KR files [message #1307] |
Fri, 07 February 2014 05:42 ![Go to next message Go to previous message](/theme/default/images/down.png) |
nina
Messages: 2 Registered: February 2014
|
Member |
|
|
Hello,
I would like to do an analysis which estimates the effect of child vaccination on anthropometric outcomes while using all DHS Standard surveys which are available.
Therefore I use the KR files and the height and weight data (HW files) based on the new WHO growth reference.
I tried to merge the Height and Weight files with the KR files for all DHS countries and years where those HW-files were available.
I have some problems merging those growth data which are collected at household level. I did it as it is described: first I merged the HW files with the PR files (using hhid and hvidx from the PR files and HWHHID HWLINE from the HW files) and then I merged those newly created PR files with the KR files (using V001, V002, B16 from the KR files and HV001, HV002 and HWLINE from the newly created PR files).
My problems are
1. While merging the Egypt 2000 HW and PR files Stata doesn't match the data. It says : matched=0
I checked the identifier variables in both datasets and found observations which are available in both files according to the identifier variables. Why doesn't Stata merge those observations?
2. When I try to merge the newly created PR files with the KR files, Stata says that v001 v002 and b16 doesn't uniquely identify the observation the KR files. Therefore I created a household id variable in the KR files (taking the first 12 characters from caseid) and used this as an identifier too. But there are still observations in the KR files which can't be uniquely identified. This is mostly based on the fact that many children in the KR files have the same line number (b16) within a household. How could I solve this problem so that I can identify those children uniquely and merge the KR files with the PR files?
3. For many datasets where I was able to merge the KR files and HW files (at household level) the z-scores are only available for a small proportion of the children in the KR files in comparison to the z-scores based on the old reference from the KR files.
Therefore I calculated the z-scores (based on the new WHO reference) out of the KR files using the igrowup ado file from the WHO homepage (I used for gender the variable b4, age in months variable hw1, weight variable hw2, height variable hw3, measure variable hw15, oedema and sampling weight as not available). If I compare those calculated z-scores with the z-scores of the same observations in the HW and KR files (also based on the new WHO reference), the calculated weight-for-height variable matches with those in the HW files but the other two z-scores (weight-for-age and height-for-age) differ.
How did you calculate the z-scores in the KR and HW files. Is there a do file available?
Many thanks in advance!
|
|
|