I am creating summary analysis for records with a particular event denoted as 'X1'.  I want create one data set with records that have consecutive X1 events as well as a second data set with records that have a X1 occurrence but in non-consecutive instances which would serve as a total record set that captures all X1 events.  I created three counter fields: the first for the record iteration, the second counter starts and stops with each X1 event and the third counter counts each X1 event but reverts to zero when no X1 event is present.  When I attempt to group the consecutive and non-consecutive events separately, the output makes no sense since the totals for the first instance of X1 (which should be the same whether they are consecutive or non-consecutive) are different between the two data sets.  Here is the code for the three counter fields:   /*Creating a counter field to track the number of records for each individual account*/ data Step2; set Step1; by accountnumber; if first.accountnumber then acct_int = 1; else acct_int + 1; /*iterative statement*/ run;   /*Creating a second counter field that starts and stops with each X1 event - Consecutive*/ data Step3 (drop=_n:); set Step2; by accountnumber; if first.accountnumber then _n=0; _n+event_type='X1'; event_int_1=ifn(event_type='X1',_n,0); run;   /*Creating a third counter field that resets to zero for each non-consecutive X1*/ data Step4 (rename=(_n=event_int_2)); set Step3; by accountnumber; if first.accountnumber then _n=0; if event_type='Non-X1' then _n=0; else _n +1; run;   The output will have this layout:   accountnumber  event_type    acct_int  event_int_1  event_int_2          001                Non-X1           1              0                   0          001                     X1              2              1                   1          001                Non-X1           3               1                  0          001                     X1              4               2                  1          001                     X1              5               3                  2          002                     X1              1               1                  1          002                     X1              2               2                  2          002                Non-X1           3               2                  0          002                     X1              4               3                  1          003                Non-X1           1               0                  0               004                     X1              1               1                  1           005                     X1              1               1                  1          005                Non-X1           2                1                 0          006                Non-X1           1                0                 0          006                Non-X1           2                0                 0          006                    X1               3                1                 1   When I use the GROUP BY statement using the event_1 and event_2 variables in PROC SQL, the totals don't make sense.  Am I properly identifying the consecutive and non-consecutive records with my counters?  Any assistance would be greatly appreciated in this issue.  Thanks. ... View more