Selecting data in between two dates

[Bounce]

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

[Jagadishkatam · Accepted solution]

Could you please try below code

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