st: merging the newly created height and weight DHS data sets with child data set

[Donela Besada <dbesada85@gmail.com>]

Hello,

I was wondering if anyone could help me. I am trying to follow the WHO
instructions on how to merge the new height and age data sets with the
original child data sets. I am able to successfully merge the height
and weight data with the household member data. I am having some
trouble with the second step of merging that data set to the child
data set. When I try to merge on the variables: v001, v002 and b16, I
get the following error:

"variables v001 v002 b16 do not uniquely identify observations in the
master data"

Has anyone successfully done this and could you please help if so?


Thank you very much
Donela

WHO instructions:

The Height and Weight data collected for children at the household
level can be matched to the households, to the members, to the
mothers, or to the children.

Use HWHHID and HWLINE from the Height and Weight file with HHID and
HVIDX from the Members Recode file to merge it with the household
member data.

 Once the Height and weight data are merged to the household members’
file, the resulting file could then be merged with the mother’s and
children’s file, as follows:

 Use HV001 (cluster number) plus HV002 (household number) and HWLINE
from the member’s constructed file (or the one resulting from the
previous merge), and merge it with the corresponding V001, V002, B16
(child’s line number in the household) in the Children Recode file or
in the Births Recode file.

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/