Re: st: creating panel of household surveyed in different year

[Chamara Anuranga <kcanuranga@gmail.com>]

Dear Prakash,

keep id variable in each survey and create new variable to identify each survey.
for the dataset 1
gen svyname1="survey1"
for dataset 2
gen svyname2="survey2"

etc.
now you have 3 datasets. Merge them base on id. check the missing for svynames

egen totmiss=rowmiss(svyname*)

if rowmiss if 0 it mean those household appears in 3 rounds.


Thanks
Chamara




On Tue, May 21, 2013 at 3:57 PM, Prakash Singh <prakashbhu@gmail.com> wrote:
> Hello every one
> I had sent mail earlier also but may the subject was not appropriate
> to draw attention so I am sending this again with revised subject.
>
> 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
> (did not participated in the 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/
*
*   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/