Hi, I have dataset with two variables ID and Visits. We expect the below following visits to be present for every ID. I would like to write a query to output the following scenario. Every ID is expected to visit in incremental order of +1 from cycle1 to cycle n Example: if ID visited upto CYCLE 9 but has skipped Cycle4,5,. Then it is discrepancy and we should output Cycle4,5 as missing visit. The output should look like this. ID TERM 001 missing: CYCLE 4, DAY 1:CYCLE 4, DAY 8:CYCLE 4, DAY 15 ; CYCLE 5, DAY 1:CYCLE 5, DAY 8:CYCLE 5, DAY 15 CYCLE 1, DAY 1 CYCLE 1, DAY 2 CYCLE 1, DAY 3 CYCLE 1, DAY 8 CYCLE 1, DAY 15 CYCLE 2, DAY 1 CYCLE 2, DAY 8 CYCLE 2, DAY 15 CYCLE 3, DAY 1 CYCLE 3, DAY 8 CYCLE 3, DAY 15 CYCLE 4, DAY 1 CYCLE 4, DAY 8 CYCLE 4, DAY 15 CYCLE 5, DAY 1 CYCLE 5, DAY 8 CYCLE 5, DAY 15 CYCLE 6, DAY 1 CYCLE 6, DAY 8 CYCLE 6, DAY 15 Can someone help me on this..... Thanks
... View more
