BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Bounce
Fluorite | Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
Jagadishkatam
Amethyst | Level 16

Could you please try below code

 

 

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

 

Thanks,
Jag

View solution in original post

1 REPLY 1
Jagadishkatam
Amethyst | Level 16

Could you please try below code

 

 

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

 

Thanks,
Jag

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1453 views
  • 0 likes
  • 2 in conversation