Give a best solution

[shivagujjaru]

Id. Dateofjoining
101 21Aug2018
102 22Aug2018
103 17Aug2018
104 25Aug2018

As per series 103 should be 23 or 24 Aug . How to pick the odd one out or remove 103 row.

[Jagadishkatam]

please try

data have;
input Id Dateofjoining :date9.;
diff=coalesce(dif(Dateofjoining),0);
if not (diff<0);
cards;
101 21Aug2018
102 22Aug2018
103 17Aug2018
104 25Aug2018
105 27Aug2018
106 18Aug2018
107 30Aug2018
;

[Ksharp]

data have;
input Id Date : date9.;
format date date9.;
cards;
101 21Aug2018
102 22Aug2018
103 17Aug2018
104 25Aug2018
;

data want;
 set have;
 retain temp;
 if temp<date then temp=date;
  else flag=1;
  drop temp;
run;

[shivagujjaru]

What value does temp represent here

[Ksharp]

temp hold the max date when go through the table.

101 21Aug2018
102 22Aug2018
103 17Aug2018
100 18Aug2018
104 25Aug2018
;

103 and 100 is you want removed ?