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

[Nick Cox <njcoxstata@gmail.com>]

Please show the -merge- command you typed to increase the chance of a
good answer.
Nick
njcoxstata@gmail.com


On 22 August 2013 14:55, Donela Besada <dbesada85@gmail.com> wrote:
> 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/

*
*   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/