Selecting data in between two dates

Bounce — Wed, 30 Oct 2019 03:08:07 GMT

Hello I have a dataset where there are three columns with dates. Column A contains a start date, Column B contains an end date and Column C contains the event date. I would only want to retain the rows of data in which the Event Date (Column C) falls between the Start Date (Column A) and End Date (Column B).

For example, the data I have:

ID A B C

1 10JAN19 06FEB19 01JAN19

2 02JAN19 27FEB19 31JAN19

3 09JAN19 03MAR19 26FEB19

4 12JAN19 19APR19 30JUN19

5 30JAN19 20MAR19 29APR19

And the data I want:

ID A B C

2 02JAN19 27FEB19 31JAN19

3 09JAN19 03MAR19 26FEB19

Any help appreciated 🙂 thank you

Re: Selecting data in between two dates

Jagadishkatam — Wed, 30 Oct 2019 04:57:26 GMT

Could you please try below code

data want;
set have;
if columnA<=columnC<=columnB;
run;

topic Re: Selecting data in between two dates in New SAS User

Selecting data in between two dates

Re: Selecting data in between two dates