Hello everyone, I couldn't come up with a program that adjust dates (in duplicates: use start date from 1st record and use stop date from 2nd record) and remove duplicate records. data test; input id $ startdate yyyymmdd. stopdate yyyymmdd. ; datalines; 101 20150304 20190302 101 20190302 20160622 102 20150916 20190914 102 20190914 20161211 103 20060530 20070530 104 20070413 20071113 ; Output needed: 101 20150304 20160622 102 20150916 20161211 103 20060530 20070530 104 20070413 20071113 I'm tired of thinking and thanks a ton for solving my problem...
... View more
