topic Re: INTNX for hours in SAS Programming

INTNX for hours

Tommer — Thu, 26 May 2022 14:57:42 GMT

Hi,

Here I want time 1.5 hours before date, but intnx is calculating 2 hours instead. What am I missing?

data chkl;
date="2021-02-01T09:30";
date2= intnx("hour",input(date,is8601dt.),-1.5,"s");
format date2 is8601dt.;
run;

Tom — Thu, 26 May 2022 15:04:58 GMT

INTNX() is for changing by intervals. Not fractions of an interval.

If you want to subtract an hour and a half just subtract an hour and a half.

date2= input(date,is8601dt.) - '01:30:00't  ;