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

nataliavanessa0 — Thu, 16 Sep 2021 19:30:11 GMT

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

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

Reeza — Thu, 16 Sep 2021 20:36:11 GMT

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

topic Selecting first row meeting value, if not last row per id in SAS Programming

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

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