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
Difference between F.E. model, OLS and 2SLS regressions?Hello, In my work, I try to investigate whether differences exist between Europe and around the glo…
Creating month-of-the-year dummiesHello everyone! I have a dataset with monthly data. My date variable is in the format of "YM", so, …
Output OLS RegressionHello everyone. For my thesis I have to run a OLS regression estimated cross-sectionally by industr…
UK Stata Conference, 9-10 September 2021 (online): announcement and first callYou are warmly welcomed to attend the 27th London Stata Conference! Like last year, the conference …
Omitted Variable Because of CollinearityHello everyone, I hope everyone is doing well! I'm currently trying to do a regression of several d…
Subscribe to:
Post Comments (Atom)
0 Response to Matching different ID between two periods
Post a Comment