Calculating difference in Date/Time fields

Jyuen204 — Tue, 20 Jun 2023 16:49:50 GMT

I have a data set with a Start and End Datetime.

Trying a few things to compute the difference between the end and start time.

But the results (below) are not getting anything back.

proc sql outobs=100;
select ACTION_END_DTM, ACTION_START_DTM, ACTION_START_DTM-ACTION_START_DTM as AHT, INTCK("interval",ACTION_END_DTM , ACTION_START_DTM) as AHT from calls_closed;
run;

Re: Calculating difference in Date/Time fields

Reeza — Tue, 20 Jun 2023 16:53:36 GMT

INTCK("interval",ACTION_END_DTM , ACTION_START_DTM)

You need to specify the interval, ie minute, day, month, week, not interval.

Or format AHT,

action_end_dtm - action_start_dtm as aht format=time. ....

You also need to give them unique variable names and your subtracting the same variable from itself.

@Jyuen204 wrote:

I have a data set with a Start and End Datetime.

Trying a few things to compute the difference between the end and start time.

But the results (below) are not getting anything back.
proc sql outobs=100;
select ACTION_END_DTM, ACTION_START_DTM, ACTION_START_DTM-ACTION_START_DTM as AHT, INTCK("interval",ACTION_END_DTM , ACTION_START_DTM) as AHT from calls_closed;
run;

topic Re: Calculating difference in Date/Time fields in SAS Programming

Calculating difference in Date/Time fields

Re: Calculating difference in Date/Time fields