Out of a data set of one patient, I'm trying to locate the first date and set it as a value 1 in a new colum(episodestart)
Then I want to go through each row in order and figure out if it's within 30 days of the previous episodestart column record that was a 1 and mark it with a 0.. If it is...
I have basic data like this.
and I want to add the column you see out the far right.
Identity ID Contactid Desired Column
1 A 123 1
2 A 124 1
3 A 125...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.