Re: st: merging datasets

[Prakash Singh <prakashbhu@gmail.com>]

Dear Khalida,
What I suspect from information you have provided that one data set is
at household level and the other is at individual level. SO if you
have to work on individual level information you need to make unique
id in such a way that it takes care of individual in the family and
then merge it.

Otherwise, you need to collapse the individual level file to household
level file and then merge.


Hope it works for you.



Prakash

On Sat, Sep 1, 2012 at 8:03 PM, Khalida Akhtar Choudhury
<310543@soas.ac.uk> wrote:
> Hi,
>
> I need to merge household head in my dataset. In one of my datasets, I
> have a variable which describes the household head, however, in my
> other datasets, I do not. The id that is used across all datasets is
> not unique, so that individuals from the same household have the same
> id.
>
> I don't know how to merge for household head across all the datasets.
>
> Can someone help
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/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/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/