Hi all, I am trying to make a variable 'B' that will code each of the lines of A by group number. I want it to code B=1 for the first group of the first day when when A=1, B=2 for the second group of that day when A=1, etc. I need this counter to restart the next day (and by next participant). Any ideas on how to get this to work? Thank you! Data I have: ID Day A 1 1 1 1 1 1 1 1 . 1 1 1 1 1 1 1 1 1 1 1 . 1 2 . 1 2 1 1 2 1 1 2 . 1 2 1 1 2 . 2 1 1 2 1 1 2 1 1 2 1 . 2 1 . 2 1 1 2 1 1 2 2 1 2 2 . 2 2 1 Data I want: ID Day A B 1 1 1 1 1 1 1 1 1 1 . . 1 1 1 2 1 1 1 2 1 1 1 2 1 1 . . 1 2 . . 1 2 1 1 1 2 1 1 1 2 . . 1 2 1 2 1 2 . . 2 1 1 1 2 1 1 1 2 1 1 1 2 1 . . 2 1 . . 2 1 1 2 2 1 1 2 2 2 1 1 2 2 . . 2 2 1 2
... View more