Hi ,I want Worked_Date should fall Between Start_date and End_Dae in new column
Worked_Date | Start_Date | End_Date |
27/04/2016 | 5/25/2016 | 5/25/2016 |
1/6/2016 | 5/26/2016 | 5/27/2016 |
1/7/2016 | 5/28/2016 | 5/29/2016 |
1/8/2016 | 5/30/2016 | 5/31/2016 |
1/9/2016 | 5/31/2016 | 6/1/2016 |
1/10/2016 | 6/1/2016 | 6/5/2016 |
1/11/2016 | 6/2/2016 | 6/6/2016 |
1/12/2016 | 6/6/2016 | 6/7/2016 |
2/5/2016 | 6/7/2016 | 6/8/2016 |
2/6/2016 | 6/8/2016 | 6/9/2016 |
Post test data in the form of a datastep!!!
As such this is just assuming that those are dates:
data want; set have; indicator=ifn(start_date <= worked_date <= end_date,1,0); run;
I dont understand this question. In none of your records do Worked_Date fall between Start_Date and End_Date? What do you want the new column to contain?
sorrry for the miscommunication, kind ignore the previous table.
Hi i have (Project) start_date and End_Date and Worked_Date and i want to create indicateor for Worked_Date weather correctly falling between Start_Date and End_Date .
Project | StartDate | EndDate | Worked_Date |
1 | 5/25/2016 | 4/9/2017 | 1/1/2017 |
2 | 4/10/2017 | 12/31/2199 | 2/7/2017 |
3 | 5/25/2016 | 12/31/2199 | 3/9/2017 |
4 | 5/25/2016 | 12/31/2199 | 4/11/2017 |
5 | 5/25/2016 | 12/15/2016 | 12/10/2016 |
6 | 12/16/2016 | 12/31/2199 | 3/13/2017 |
7 | 5/25/2016 | 2/19/2017 | 1/12/2017 |
8 | 5/25/2016 | 12/31/2199 | 4/7/2017 |
Well, just see of if work date date falls between start and end dates, and assign a indicator value of the comparison result. What part is it you don't know how to do? What have you tried so far?
Post test data in the form of a datastep!!!
As such this is just assuming that those are dates:
data want; set have; indicator=ifn(start_date <= worked_date <= end_date,1,0); run;
Thanks for the answer RW9.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.