topic Re: How to find a date interval with a specific days in SAS Programming

How to find a date interval with a specific days

CathyVI — Mon, 18 Mar 2024 18:24:44 GMT

Hello,

I want to determine whether an individual completed any form (event_date) within 60 days of their program (end_date).

I have a demo data below and am struggle with the code. Any help please.

data A;
input ssn @4 start_date :date9. @14 end_date :date9. @24 event_date :date9. ;
infile datalines  firstobs=2 ;
informat start_date end_date event_date date9.;
format start_date end_date event_date date9.;
datalines;
id    start_date	    end_date	 event_date   
101 01DEC2021	28FEB2022	09NOV2020    
101 16OCT2019	18NOV2019	03FEB2020    
102 16OCT2019	18NOV2019	07MAY2020    
103 03FEB2022	02MAY2022	08JUL2022    
103 03FEB2022	12FEB2022	15JAN2023    
;;
run;

For example, id 101 first end_date was 28FEB2022 but the event date was less than 60days there the first id will not be my desired output.

BUT id 101 second end_date was 18NOV2019but the event date is 60days more than the end_date therefore the second ID will be part of my desired output. I don't want to dedup any data by id so I can capture all multiple events within one person(id).

Thanks in advance!

Re: How to find a date interval with a specific days

yabwon — Mon, 18 Mar 2024 18:40:33 GMT

Do you mean like this:

data want;
  set A;
  where end_date+60 < event_date;
run;

Bart

Re: How to find a date interval with a specific days

Mazi — Mon, 18 Mar 2024 18:41:26 GMT

Do you wish to calculate the difference between the event date and end date?

Re: How to find a date interval with a specific days

CathyVI — Mon, 18 Mar 2024 19:00:42 GMT

@Mazi @yabwon I wish to find those dates that "if event_date is within 60days after the end_date. Those are the id of interest. Any event date that is more than 60 days after the end date is not of interest.

Re: How to find a date interval with a specific days

Mazi — Mon, 18 Mar 2024 19:17:56 GMT

The second ID is more than 60 days after the event date. In your first post you said you’d want this record in your output.

Or am I missing something ?

Re: How to find a date interval with a specific days

CathyVI — Mon, 18 Mar 2024 19:30:34 GMT

@Mazi if you have 60days to the enddate (enddate+60) and the results is within the event_date, thats what I want. If you add 60 to the enddate and the results is more, I want a separate output of it.

Re: How to find a date interval with a specific days

Mazi — Mon, 18 Mar 2024 19:35:56 GMT

Data want;
set a;
diff = event_date - end_date;
If 0<=diff<=60 then flag = 1;
else if diff >60 then flag= 2;
run;

Re: How to find a date interval with a specific days

Mazi — Mon, 18 Mar 2024 19:38:22 GMT

If flag = 1 then event_date is 60 days or less after end_date

If flag = 2 then event_date is more than 60 days after end_date