436734_en-US

liliconcom

Excluding data by date

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

AnalyticsData TableScriptingRe: Excluding data by date

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

Re: Excluding data by date

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