topic Re: Identify first and subsequent data value in rows in SAS Data Management

Identify first and subsequent data value in rows

AZIQ1 — Sat, 07 Apr 2018 03:58:29 GMT

Hi,

I need help with creating a flag whenever there is the first occurrence of value >180, and order the subsequent values that are >18

Have:

want:

Thank you, I will appreciate your help.

art297 — Sat, 07 Apr 2018 04:22:39 GMT

Here is one way:

data want (drop=counter);
  set have;
  if value gt 180 then counter+1;
  flag=ifn(value gt 180,counter,0);
run;

Art, CEO, AnalystFinder.com

AZIQ1 — Sat, 07 Apr 2018 04:31:07 GMT

Thank you so much, it worked!!!!