03-30-2012 09:28 AM
What can I do to reset the counter on a given condition.
usually you would use _N_ to sequence but how do I get this output
How do I get it to reset. Maybe I do not understand what _N_ denotes properly. Please help. Thanks in advance.
03-30-2012 09:39 AM
if lag(var1)='N' then count=1;
03-30-2012 09:43 AM
Another method is to reset the counter on the record that marks the end of the group. But do it AFTER writing the current count to the output dataset.
if var1='N' then count=0;
Need further help from the community? Please ask a new question.