hashman, how would you count the time between Logins? to determine the duration of the cycle in minutes ... View more

Perfect, dude! Thank you so much! ... View more

I need the information on a dataset. Would be great If I had a new column/variable (CYCLE) and at the end of each cycle, a classification for the prior one.  For example, expected structure:   TIME CODE TRANSACTION CYCLE 7:00:30 801 Login 7:00:35 405 Transaction X 7:00:40 404 Transaction Y X Cycle 7:02:30 801 Login 7:02:35 404 Transaction Y 7:02:40 404 Transaction Y     Y Cycle 7:03:60  801  Login 7:04:15  405  Transaction X 7:04:20  404  Transaction Y 7:05:01  405  Transaction X 7:06:03  409  Transaction X     X Cycle The variable CODE is a character variable. The value of 'CODE' it is indeed related to the value of 'TRANSACTION', but I do that classification in a prior step, for example: IF CODE = '801' THEN TRANSACTION = 'Login'; ELSE IF CODE IN ('405','409') THEN TRANSACTION = 'Transaction X'; ELSE TRANSACTION = 'Transaction Y';     ... View more

The amount of time the user is logged in it is not important here.  The LOGIN transaction is just a flag to let me know that another cycle began/ended   What I really need to do is to identify the transactions between those LOGIN transactions   not sure If i get your suggestion...could you give me an example of what you thought?     ... View more