Here is a small sample of a data set that looks like this:  DATA HAVE; INPUT ID $10. START_DT :MMDDYY10. END_DT :MMDDYY10.; format START_DT MMDDYY10. END_DT MMDDYY10.; datalines; 1004064609 04/01/2023 12/31/2023 1004064609 01/01/2024 12/31/3999 1004064623 04/01/2023 12/31/2023 1004064623 01/01/2024 12/31/3999 1004064703 03/06/2024 03/28/2024 1004064703 03/29/2024 12/31/3999 1004064706 04/01/2023 12/31/2023 1004064706 01/01/2024 12/31/3999 1004064724 04/01/2023 06/30/2023 1004064724 07/01/2023 11/30/2023 1004064724 12/01/2023 12/31/2023 1004064724 01/01/2024 12/31/3999 1004064726 04/01/2023 10/31/2023 1004064726 12/05/2023 12/31/2023 1004064726 01/01/2024 05/31/2024 1004064726 06/01/2024 12/31/3999 1004064727 04/01/2023 12/31/2023 1004064727 01/01/2024 12/31/3999 ; RUN; For each unique ID I want to collapse continuous date spans whenever possible. For example, for the first ID 1004064609 I would want a single record where START_DT = 04/01/2023 AND END_DT = 12/31/3999. Note that some IDs will have multiple date spans that aren't continuous and those should continue to exist as separate records. What's a solution to do this? Thank you. ... View more