Hi!
I have a problem that I wonder if anybody can help me with.
I have panel data of individuals were the time period is 2 years. Each individual have a unique identification number (indID) and a house ID which is unique in each region but different regions can have the same number.
What I want to do now is to see if an individual have moved to a new house or not (coded as a 1) and thus changed house ID (there is a theoretical chance that a person moves between two houses with the same house ID but different regions).
I don't know how to solve this but a first start is the following.
xtset indID year
bysort indID: gen Change=1 if house ID!=houseID[_n+1]
My problem with this code is that it gives a 1 in all houses in period 2, independently if houseID have changed or not.
Any good advice or alternative solutions?
Related Posts with Matching different ID between two periods
xtabond2 help and adviceHello I have a panel data with firm-year data. number of firms approx 1000 and number of years 10 I…
Labelling studies in metaprop_oneHello, I'm a long time reader of these forums but first time poster! Please forgive me for any mist…
Help with subinstrHi, I need help removing " ' " from some observations from one variable 'ccccccc 'errrrrrrr 'rtrtrt…
Margins (and marginsplot) do not produce a result after cmclogitDear all, I am running the following cmclogit (conditional logit / McFadden logit) model (and other…
Tabulate by year based on start-/end datesDear Statalist, I have a dataset that consists of observations of people who are/were part of the b…
Subscribe to:
Post Comments (Atom)
0 Response to Matching different ID between two periods
Post a Comment