DATA table1;
infile datalines DELIMITER=',';
INFORMAT id 2. type $10. date date2 MMDDYY10. ;
INPUT id date type date2;
format date date9.
date2 date9.;
DATALINES;
1,02/09/2012,BIG,02/09/2012
2,05/16/2012,BIG,05/18/2012
2,06/18/2012,BIG,06/18/2012
2,06/18/2012,SMALL,
3,08/08/2011,BIG,08/08/2012
3,09/13/2011,BIG,09/13/2012
4,06/08/2016,BIG,06/12/2016
5,08/16/2012,BIG,08/16/2012
5,08/15/2012,SMALL,
6,09/05/2012,BIG,09/06/2012
7,09/05/2012,BIG,09/05/2012
7,02/13/2013,BIG,02/13/2013
7,08/03/2011,BIG,08/03/2011
7,05/09/2012,BIG,05/09/2012
7,04/24/2013,SMALL,
8,03/31/2017,BIG,04/01/2017
8,03/06/2017,SMALL,
9,02/17/2016,SMALL,
;
run; I want to remove the observation if in our example of id 5 date is 8/16/2012 for BIG type while for the same id type SMALL is 8/15/2012 the difference in date is 1 thus I would like to remove that observation which is greater and less than 5 days apart. So my dataset has to give only one record for id 5 5,08/15/2012,SMALL, but not 5,08/16/2012,BIG,08/16/2012 only between different type SMALL and BIG but not between themselves. Sas EG-7.12
... View more