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
Align boxplot and line graphDear Statalisters, I'm trying to combine a line graph with a boxplot in one row. The axes have the …
How to generate dataset to test different mixed logit specifications using Monte Carlo experimentDear Statalist, I want to replicate the results of the Monte Carlo experiments reported in Chang an…
Esttab: Drop factor variables in regression outputI would like to drop some factor variable coefficients in my regressions, since they are mere contro…
x-axis scale for metanHi all, I am trying to create a forest plot using metan with a standardized scale of -24, 0, 1, 2, 5…
How to Perform Functions within groups in a dataset?In my data set, I have a variable called "STATEID" which identifies the state to which the responden…
Subscribe to:
Post Comments (Atom)
0 Response to Matching different ID between two periods
Post a Comment