I have a raw data and not sure how to flag if service_from_date is not a continuous month. for example, from observation1-3, need flag=1; from observation 4-5, need flag=2; from observation 6-13, need flag=3. observation 1-5 has a same provider, but there is a gap (not continuous) between observation 3 and 4. MEMBER_ID SERVICE_FROM_DATE SERVICE_THROUGH_DATE SERVICE_PROVIDER_ID ABC 01/05/2017 01/05/2017 64058469 ABC 02/24/2017 02/24/2017 64058469 ABC 03/08/2017 03/08/2017 64058469 ABC 07/10/2017 07/10/2017 64058469 ABC 08/21/2017 08/21/2017 64058469 ABC 03/25/2017 03/25/2017 64089900 ABC 04/30/2017 04/30/2017 64089900 ABC 05/28/2017 05/28/2017 64089900 ABC 06/25/2017 06/25/2017 64089900 ABC 07/23/2017 07/23/2017 64089900 ABC 08/20/2017 08/20/2017 64089900 ABC 09/24/2017 09/24/2017 64089900 ABC 10/22/2017 10/22/2017 64089900 wanted results: MEMBER_ID START_DT END__DT SERVICE_PROVIDER_ID ABC 01/05/2017 03/08/2017 64058469 ABC 07/10/2017 08/21/2017 64058469 ABC 03/25/2017 10/22/2017 64089900
... View more