Hello, I have the following data set: Student_id Week1 Week2 Week3 Week4 Week5 Week6 123 0 4 3 0 0 2 124 4 3 4 4 4 4 125 2 0 0 3 2 1 126 0 2 3 0 2 0 127 0 0 0 0 0 0 0 means that the person didn't attend any classes in that week, 1/2/3 means how many classes student attended in the week. I need to produce a report with students who didn't attend any classes for at least 2 weeks in a row. Does anyone have an idea how to do it? Thank you for your help.
... View more