Hello all, I illustrated my question in the following example. Could you please help me to generate the desired output in SAS ? Basically, we would like to expand the service period and ignore any gaps within 30 days. ID FROM_DT THRU_DT 10 02/03/2014 02/25/2014 10 03/01/2014 04/02/2014 10 04/03/2014 05/05/2014 10 07/07/2014 07/30/2014 10 08/20/2014 08/25/2014 11 03/02/2013 05/03/2013 11 05/08/2013 05/20/2013 Desired output should look like this: ID FROM_DT THRU_DT 10 02/03/2014 05/05/2014 10 07/07/2014 08/25/2014 11 03/02/2013 05/20/2013 Thank you very much!
... View more