Dear Stata Community,
I have the following dataset:
Household_ID Personal_ID Round
1 1 1
1 2 1
1 2 2
1 3 2
2 1 1
2 1 2
I basically want to drop the observations in BOLD in order to create a cross sectional dataset, where each observation if recorded in round 1 and 2 only appears in the latest round. Ideally my dataset then would look like:
Household_ID Personal_ID Round
1 1 1
1 2 2
1 3 2
2 1 2
Anyone has an idea on how to code this?
All the best!
Related Posts with Drop Observations which are contained more than once in Panel Data
Slope coefficients for different quintiles of ranksHello all, I have an unbalanced panel data set on funds and their respective 3 Factor alphas for ea…
Binscatter plot warningHello, I just want to know whether getting the following warning is normal for binscatter plots, I …
Hardware to optimize processing large text filesHi list, I'm buying new machines for my lab and would like to optimize the speed with which we proce…
Save results from the first stage in ivprobitHello! I am doing : ivprobit any $GR_geo ( gdp_perc = $x_eco $x_eco_lag_1 ), twostep first estimate…
Panel data - constant dependent variable across individuals not timeHello, I wanted to seek for someone's advice as I have run into a number of problems with my analys…
Subscribe to:
Post Comments (Atom)
0 Response to Drop Observations which are contained more than once in Panel Data
Post a Comment