Hello, I have the following data: personID caretype date 1 primary 18000 1 primary 18001 1 specialty 18005 1 primary 18007 1 specialty 18008 1 specialty 18009 1 primary 18020 I would like to create a count variable where the count starts over every time it reaches the caretype value of "primary". For example, I would like my data to look like the following: personID caretype date count 1 primary 18000 1 1 primary 18001 1 1 specialty 18005 2 1 primary 18007 1 1 specialty 18008 2 1 specialty 18009 3 1 primary 18020 1 Any ideas on how to do this? Thank you!
... View more