Hi all,
Complete newbie here. I've been trying to figure out the following without success. My set of data contains a variable X with observations that repeat (i.e., the number of times the same person had different observations). I'm trying to figure out how to keep only the last observation in my data set.
It looks something like this:
X Y Z
6 Yes 10/31/1990
3 No 2/10/2010
3 No 2/28/2020
4 No 5/30/2016
6 No 12/10/2020
Observations 6 and 3 repeat for X. I only want to keep the last observations in X (while keeping everything else). My hope is that after keeping only the last observations of X, I will be left with something like this:
X Y Z
3 No 2/28/2020
4 No 5/30/2016
6 No 12/10/2020
Any help would be much appreciated!
Related Posts with Keeping Last Observation
Formatting a 3-way Stata table like a SAS tableHi Statalist, I would like to have my 3-way Stata table here: Array Be formatted in a similar way …
Sampling without replacementA first question. Is there a way to sample without replacement in Stata? I would like a random ident…
Change in Change (Athey Imbens 2006) with multiple time periods and RobustnessHi I am trying to do robustness of my DD estimation with multiple time periods in data (both before…
Issues using PPML Fixed Effects Gravity ModelHello all, I am a masters student using the gravity model to try and understand trade between the f…
Fmolscan PANEL FMOLS be used with I(1) dependent variable and i have 4 independent variables one of them …
Subscribe to:
Post Comments (Atom)
0 Response to Keeping Last Observation
Post a Comment