Excluding data by date

Question

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

Thierry_S · Answer

Hi,

A simple way to achieve this would:

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

Best,

TS

dale_lehman · Answer

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).

Untitled.jmp