How to filter odd dates

Ajayvit — Sat, 12 Aug 2023 03:58:10 GMT

Hi Team,

I need help for below scenario.

All dated will be in ascending order and if any date is smaller than its previous date then that is odd and need to be filter out.

I applied lag function but it is getting applied on entire variable not on group if 1 and 2 separately.

data test1;
input id date$12.;
datalines;
1 01JAN2010
1 04JAN2010
1 08JAN2010
1 07JAN2010
1 11JAN2010
2 05JAN2010
2 06JAN2010
2 04JAN2010
2 07JAN2010
2 10JAN2010
;
RUN;

Expected output:

1 07JAN2010

2 04JAN2010

Re: How to filter odd dates

Kurt_Bremser — Sat, 12 Aug 2023 07:02:28 GMT

Before doing anything else, convert the strings to SAS dates by using the INPUT function with the DATE9. informat.

Then it's easy:

data want;
set test1;
by id;
if date lt lag(date) and not first.id;
run;

topic How to filter odd dates in SAS Programming

How to filter odd dates

Re: How to filter odd dates