In the example below, group x has a counter limit of 3 and group y has a counter limit of 5. In each group, the counter starts when the MW value goes from >0 to 0.  Any ideas on how to code this?  In the real application of this, I have multiple "groups" all with different "counter" limits.  Any help is much appreciated!   Here is an example dataset and the result I am trying to return: ... View more

Here is an output I'm after: Anytime the MW value changes from >0 to 0 I want to start a counter and reset the counter when MW >0, as shown above.   I have achieved this with the code below.  I'm looking for a way to do this more efficiently, as there are times when I may need to count to up to 72+. data test; set data; if MW = 0 and lag(MW) > 0 then counter = 1; if lag(counter)=1 and MW=0 then counter=2; if lag(counter)=2 and MW=0 then counter=3; if lag(counter)=3 and MW=0 then counter=4; if lag(counter)=4 and MW=0 then counter=5; if lag(counter)=5 and MW=0 then counter=6; if lag(counter)=6 and MW=0 then counter=7; if lag(counter)=7 and MW=0 then counter=8; if lag(counter)=8 and MW=0 then counter=9; if lag(counter)=9 and MW=0 then counter=10; if lag(counter)=10 and MW=0 then counter=11; run; ... View more