I wanted to count number of visits in a row (each week) for each customer. The problem I'm having is, if I'm using if.first counters, i need to sort the data by the two variables - customer id and a flag whether they visited that week or not. However, I need to keep the data sorted by date and customer id, as I'm interested in sequential observations. For example: Week_end Cust_id Visit_flag 01JAN2017 01 0 08JAN2017 01 1 15JAN2017 01 1 22JAN2017 01 0 29JAN2017 01 1 05FEB2017 01 0 01JAN2017 02 0 08JAN2017 02 1 15JAN2017 02 1 22JAN2017 02 1 29JAN2017 02 1 05FEB2017 02 0 The output i want, is how many weeks in a row (max) a customer has visited: Cust_id max_seq_visits 01 2 02 4 Thanks in advance for any help.
... View more