Scenario 2)
data have;
input (DATE1 DATE2 ) (:date11.);
format date: date9.;
cards;
20-Apr-21 1-Jan-21 31-Dec-99
20-Apr-21 1-Jan-21 31-Dec-99
20-Apr-21 1-Jan-21 31-Jan-00
20-Apr-21 1-Jan-21 31-Dec-99
20-Apr-21 1-Jul-19 31-Dec-20
20-Apr-21 1-Jul-19 31-Dec-20
27-Apr-21 1-Jul-19 31-Dec-20
28-Apr-21 1-Jul-19 31-Dec-20
29-Apr-21 1-Jul-19 31-Dec-20
;
data temp;
set have;
by date1 date2 notsorted;
if first.date1 then group=0;
group+first.date2;
run;
proc sql;
create table want as
select *
from temp
group by date1
having count(distinct group)>1 and group=1;
quit;
... View more
