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

[Nick Cox <njcoxstata@gmail.com>]

My own guess is that Prakash's previous post was ignored because it
was too vague about precise data structure and the revised post
doesn't add much.  At least that is why I deleted it. A specific
example showing what you have is usually preferable to a long verbal
discussion.

The solution below seems unnecessarily complicated. Splitting the
dataset into three and then -merge-ing them back again is only
possible if there is some identifier in the dataset that tells you
which survey round is being referred to. Why not just do it in place?

At its simplest the number of rounds in which each household
participated may just be the number of times the household appears in
the dataset. Otherwise there should be some round identifier. There
seems little point in speculating about variables, as Prakash can
(please) give concrete details.

Same applies to entry and exit: show us how the data are held, and
specific suggestions are then much easier.

Nick
njcoxstata@gmail.com


On 21 May 2013 11:42, Chamara Anuranga <kcanuranga@gmail.com> wrote:
> 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.
*
*   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/