topic Re: How to create new column should fall between Start_Date and End_Date in SAS Programming

How to create new column should fall between Start_Date and End_Date

sivastat08 — Thu, 20 Apr 2017 11:41:46 GMT

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

Re: How to create new column should fall between Start_Date and End_Date

PeterClemmensen — Thu, 20 Apr 2017 11:44:29 GMT

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?

Re: How to create new column should fall between Start_Date and End_Date

sivastat08 — Thu, 20 Apr 2017 12:30:45 GMT

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

Re: How to create new column should fall between Start_Date and End_Date

LinusH — Thu, 20 Apr 2017 12:56:31 GMT

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?

Re: How to create new column should fall between Start_Date and End_Date

RW9 — Thu, 20 Apr 2017 13:01:55 GMT

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;

Re: How to create new column should fall between Start_Date and End_Date

sivastat08 — Thu, 20 Apr 2017 14:32:42 GMT

Thanks for the answer RW9.

Re: How to create new column should fall between Start_Date and End_Date

sivastat08 — Thu, 20 Apr 2017 14:39:01 GMT

Thanks for your motivation LinusH..going forward i will try to do.