Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: merging the newly created height and weight DHS data sets with child data set
From
Nick Cox <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: merging the newly created height and weight DHS data sets with child data set
Date
Thu, 22 Aug 2013 15:01:27 +0100
Please show the -merge- command you typed to increase the chance of a
good answer.
Nick
[email protected]
On 22 August 2013 14:55, Donela Besada <[email protected]> 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/