I have a data set with some student ids and the dates they were in attendance along with the number of classes they had taken on that particular day of attendance. Another data set with all the calendar days are also available. I want to flag those students that have taken more than 6 classes over a rolling 7 calendar day period. The goal is to identify the dates that the student exceeded that threshold, in other words the same student could have met that threshold on multiple dates. Any idea how I would be able to do that? Any help is much appreciated. Thanks !
... View more