I need to consolidate one member’s multiple records with consecutive dates into one. That is, one member has multiple records with the start date of one records being the next day of the previous record’s end date.  Here is one example:   Member_ID   Eff_Date   Term_Date   Sequence_ID --------- ---------- ---------- -------------------- 123456789   2005-01-01   2006-01-31   1 123456789   2006-02-01   2007-02-14   2 123456789   2007-02-15   2007-05-11   3 123456789   2007-05-12   2008-02-28   4 123456789   2008-02-29   2008-12-31   5 123456789   2009-11-01   2009-12-31   6 123456789   2010-01-01   2010-08-11   7 123456789   2010-08-12   2017-12-31   8 The end result I'm looking for would be two records for this member like this. Member_ID   Eff_Date   Term_Date   Sequence_ID --------- ---------- ---------- -------------------- 123456789   2005-01-01   2008-12-31   1 123456789   2009-11-01   2017-12-31   2   Any idea about how to deal with this in SAS? ... View more