@JeffMaggio I have been trying your logic you suggested and I still can't seem to wrap my head around how to make it work.  Here is a sample of my data, along with what I am expecting, I hope this clarifies some questions.   Member_ID Discharge_Date Diagnosis Service_Date Diagnosis 0001 05JAN2019 428 08JAN2019 428 0001 28FEB2019 123 04MAR2019 922 0001 11JUN2019 410     0002 02AUG2019 238 29AUG2019 238 0002 01SEP2019 210     0002 04NOV2019 308 12DEC2019 242 0003 20DEC2019 105 22DEC2019 105 0004 01MAR2019 124 04APR2019 124 0005 30APR2019 185 09MAY2019 252   So in this example I am looking to count the number of days between the discharge date and new service date.  However the following needs to match.  The member id needs to match along with the diagnosis code.  So I would want to end up with something like the following:   Member_ID Discharge_Date Diagnosis Service_Date Diagnosis Day Count 0001 05JAN2019 428 08JAN2019 428 3 0002 02AUG2019 238 29AUG2019 238 27 0003 20DEC2019 105 22DEC2019 105 2 0004 01MAR2019 124 04APR2019 124 34   Once I have that Day Count field I can start to build my flags.     Member_ID Discharge_Date Diagnosis Service_Date Diagnosis Day Count Flag 0001 05JAN2019 428 08JAN2019 428 3 1-7 0001 05JAN2019 428 08JAN2019 428 3 1-30 0002 02AUG2019 238 29AUG2019 238 27 1-7 0002 02AUG2019 238 29AUG2019 238 27 1-30 0003 20DEC2019 105 22DEC2019 105 2 1-7 0003 20DEC2019 105 22DEC2019 105 2 1-30 0004 01MAR2019 124 04APR2019 124 34 na     So with each flag, it will duplicate the data since the members should fall into each bucket.     Thank you again! ... View more

@JeffMaggio  Thank you, I am playing around with your code now to see what it looks like.  The dates are just in a date9. type format.  I was also reading up on the SAS Lag function, but I still haven't gotten my mind around that.   Thanks for the start, I will respond with good/bad news! ... View more