st: mapping household surveyed in different year

[Prakash Singh <prakashbhu@gmail.com>]

Hello every one
I am working with survey dataset of more than three rounds. The
identification code for each household is similar in all the rounds.

Now there are some households which are surveyed in all the years,
there are some households surveyed in some year but not in other years
(not participated in survey). Now I want to map the households so that
I can know which household is surveyed in more than two rounds and
also want create panel of household which are surveyed in all the
years.

I am also interested in entry and exit of households, where entry
means new household coming in the subsequent round of survey and exit
means leaving the survey in the subsequent round of survey.

Please suggest how should I workout this problem.

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