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
bootstrap: 'size() must not be greater than number of clusters' and 'insufficient observations to compute bootstrap standard errors'- Add row total to frequency table with asdoc
- Interpreting two cross-level interaction effects at the same time in MLM
- sorting issue with multiple imputations
- Reshape panel data with long and wide variables
Subscribe to:
Post Comments (Atom)
0 Response to Drop Observations which are contained more than once in Panel Data
Post a Comment