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!