topic Re: check if 1AM falls between two timestamps in SAS Programming

check if 1AM falls between two timestamps

dataMart87 — Mon, 02 Oct 2023 03:12:51 GMT

Hi, how do I create a flag, WANT, that checks if 1AM falls between two timestamps?

data task1;  
   input ID :$2. BEG_DT_TIME :datetime18. END_DT_TIME :datetime18. WANT;
   format BEG_DT_TIME END_DT_TIME datetime20.;
cards;
AA 28SEP2023:22:00:00.00 29SEP2023:02:00:00.00 1
BB 28SEP2023:07:30:00.00 28SEP2023:13:30:00.00 0
CC 28SEP2023:20:00:00.00 29SEP2023:00:00:00.00 0
DD 29SEP2023:00:00:00.00 29SEP2023:03:00:00.00 1
EE 29SEP2023:05:00:00.00 30SEP2023:03:00:00.00 1
	;
run;

Re: check if 1AM falls between two timestamps

andreas_lds — Mon, 02 Oct 2023 06:37:32 GMT

Create an new timestamp using the datepart of end_dt_time to compare it with the start and end:

Want = (beg_dt_time <= dhms(datepart(end_dt_time), 1, 0, 0) <= end_dt_time);

Re: check if 1AM falls between two timestamps

Kurt_Bremser — Mon, 02 Oct 2023 10:07:19 GMT

Use INTCK with a properly shaped interval:

data want;
set task1;
calc_want = intck('hour24.2',beg_dt_time,end_dt_time) > 0;
run;

Re: check if 1AM falls between two timestamps

dataMart87 — Tue, 03 Oct 2023 21:12:13 GMT

Thanks, @Kurt_Bremser . Curious what the .2 in hour24.2 does?

Re: check if 1AM falls between two timestamps

Kurt_Bremser — Wed, 04 Oct 2023 10:51:14 GMT

It shifts the beginning of the 24-hour period to the second hour (first hour would be 00:00). INTCK then counts how many of these beginnings are crossed.