Selecting first row meeting value, if not last row per id

[nataliavanessa0]

Hi,

After sorting by date and ID, I am trying to select the first row per id that meets a certain criteria (x > 1), but if none of the rows (per id)  meet this criteria, I want to select the last row for that id?

I appreciate any help, thanks.

Natalia

[Reeza]

data want;
set have;
by ID;
*hold value of flag across rows;
retain flag;

*initialize flag to 0 at start of each ID;
if first.id then flag=0;

*check if x >1 and flag is not 0 - has not happened before;
if x>1 and flag ne 1 then do;
    *set flag so you know it has been found;
   flag=1;
   *output record to dataset;
   output;

end;

*if last of the ID and flag is still 0 then output as well;
if last.id and flag=0 then output;

run;

---

@nataliavanessa0 wrote:

Hi,

After sorting by date and ID, I am trying to select the first row per id that meets a certain criteria (x > 1), but if none of the rows (per id)  meet this criteria, I want to select the last row for that id?

I appreciate any help, thanks.

Natalia

---