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!