topic Re: how many times a specific time of day occurs in a datetime interval in SAS Programming

how many times a specific time of day occurs in a datetime interval

dataMart87 — Mon, 24 Jan 2022 21:10:57 GMT

How do you count the number of times a specific time of day (for example 23:59, i.e. 11:59PM) occurs in a datetime interval?

data have;  
	input ID $ begDate:datetime13. endDate:datetime13.;
	format begDate endDate datetime13.;
cards;
aaa 10NOV19:01:49 10NOV19:03:49
bbb 10NOV19:22:49 11NOV19:03:49
ccc 10NOV19:22:49 12NOV19:03:49
	;
run;

Re: how many times a specific time of day occurs in a datetime interval

HarrySnart — Mon, 24 Jan 2022 21:26:50 GMT

Hi @dataMart87 , it may depend on what your use case is but an easy method would be to use the TIMEPART() function then do a count distinct. See example below

*Load data;
data have;  
	input ID $ begDate:datetime13. endDate:datetime13.;
	format begDate endDate datetime13.;
cards;
aaa 10NOV19:01:49 10NOV19:03:49
bbb 10NOV19:22:49 11NOV19:03:49
ccc 10NOV19:22:49 12NOV19:03:49
	;
run;

*Extract time;
data want;
set have;
begTimePart = timepart(begDate);
format begTimePart time.;
run;

*Get count of time appearance;
proc sql;select distinct begTimePart,count(begTimePart) 
from work.want group by begTimePart;quit;

Re: how many times a specific time of day occurs in a datetime interval

PaigeMiller — Mon, 24 Jan 2022 21:27:12 GMT

If your test is to see how many times midnight is in the interval, then the INTCK function does the job.

data want;
    set have;
    incl_midnight = intck('dtday',begdate,enddate);
run;

If you want some other time, let's say 10:45pm, I believe (untested), you subtract '22:45:00't from both begdate and enddate and then use the INTCK function.