Iterate through observations

[Victor_Guer_93]

I have the next data set(example):

ID delay

1  1  

1  2

1  3

1  4

1  3

1  4

1  0

1  1

1  2

I am trying to compute the number of times the variable delay reaches 4 or more since the first time that variable is 4 or more on the next 12 observations. If the observation is 13 or more since the first delay=4 then initialize the count.

[ballardw]

And what do you expect the output to look like?

Since you include rules like "on the next 12 observations. If the observation is 13 or more " you example data should include enough values to exercise those rules and should show the result for when you have fewer than 12 as well as more than 13.

Also, what role does ID play in the process? Do you have multiple values for ID? If so should this count or whatever be only within levels of the ID or not?

[Victor_Guer_93]

Here it is a more detailed data, there are multiple ID's:

ID delay      

1  1  

1  2

1  3

1  4

1  3

1  4

1  0

1  1

1  2

1 3

1 4

1 0 

1 1

1 2

1 3

1 4

1 1

1 2

1 3

1 4

1 0

1 1

2 0 

2 0 

2 1

. .

. .

. .

Output:

(Missing in the count variable is  like a mark of initialization of the count)

ID delay Count

1  1          0 

1  2          0

1  3          0

1  4          .

1  3          0

1  4          1

1  0          1

1  1          1

1  2          1

1 3           1

1 4           2

1 0           2

1 1          2

1 2          2

1 3          2

1 3          2

1 2         0

1 4          .

1 3          0

1 4          1

1 0          1

1 1          1

2 0           0

2 0           0

2 1           0

. .             .

. .             .

. .            .

[ballardw]

This may get you started. Note use of the code box opened with the forum's {I} icon for code and a data step for example data.

data have;
input ID delay  ;
datalines;
1  1  
1  2
1  3
1  4
1  3
1  4
1  0
1  1
1  2
1 3
1 4
1 0 
1 1
1 2
1 3
1 4
1 1
1 2
1 3
1 4
1 0
1 1
2 0 
2 0 
2 1
;
run;

data want;
   set have;
   by notsorted id;
   retain count first4 .;
   if first.id then do;
      count=0;
      first4=0;
   end;
   if delay=4 then do;
      if first4=0 then do;
         count=.;
         first4=1;
      end;
      else count+1;
   end;
   else count=coalesce(count,0);
   drop first4;
run;

I don't see anything that demonstrates what you meant by the greater than 13 though. So I'm not sure what that does.