Excluding data by date

[#1]

How can I exclude all occurences after the earliest recorded date for each patient ID without selecting each row I want to exclude? EX: I want to keep the top line and exclude the remaining

Screen Shot 2021-11-15 at 8.29.06 PM.png

[#2]

 Try the attached.  If you really want the rows excluded and not set to missing, then I imagine there is some coding that can be used (and someone will be sure to provide that).

[#3]

Hi,

A simple way to achieve this would:

1. Create a new column (Numerical, Categorical) with the formula :DATE == Col Minimum (:DATE, :ID)
2. Filter on the 0 values from the new column and Exclude the rows

Best,

TS