st: Questions on Merging Two Data sets(Individual and Household data)

["Lok Wong" <lokwong80@hotmail.com>]

Hi there,

I have two data sets: one individual, another household. The observations in
household data set are less than those in individual one
because household consists of more than one individual. Now, I want to merge
this two data sets. What should I do? In the invidiual data,
there are two variables  "household id" and "number in the household" which
could be used to identify invididuals uniquely. In the household
data, there is one variales "household id".

Individual

Household ID           Number
-----------------------------------------------------------------
11111                        1
11111                        2
11111                        3
12021                        1
12021                        2
  :                              :
  :                              :
  :                              :

Household

Household ID
------------------------
11111
12021
12099
35206


Thanks first

Best,

Lok
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/