topic Give a best solution in SAS Programming

Give a best solution

shivagujjaru — Wed, 08 May 2019 05:46:27 GMT

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.

Re: Give a best solution

Jagadishkatam — Wed, 08 May 2019 06:08:04 GMT

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
;

Re: Give a best solution

Ksharp — Wed, 08 May 2019 12:54:59 GMT

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;

Re: Give a best solution

shivagujjaru — Wed, 08 May 2019 13:27:57 GMT

What value does temp represent here

Re: Give a best solution

Ksharp — Wed, 08 May 2019 13:47:45 GMT

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 ?