topic Re: INTNX Hours and Seconds in SAS Programming

INTNX Hours and Seconds

BCNAV — Wed, 08 Jul 2020 15:10:37 GMT

I always get lost with INTNX

I have a date time variable called flightdate...example: 01JAN2014:00:28:00.000

I want to add 8 hours to this. So I use intnx('hour', t1.flightdate,8) and I get 01JAN2014:08:00:00.000

I would like the minutes to come over as well and be 01JAN2014:08:28:00.000

Any way to get this to happen?

Re: INTNX Hours and Seconds

Reeza — Wed, 08 Jul 2020 15:19:52 GMT

Make sure to specify the fourth parameter, the alignment or the default applies which is not what you want here. Instead try the 'S' option.

 intnx('hour', t1.flightdate,8, 's')

@BCNAV wrote:

I always get lost with INTNX

I have a date time variable called flightdate...example: 01JAN2014:00:28:00.000

I want to add 8 hours to this. So I use intnx('hour', t1.flightdate,8) and I get 01JAN2014:08:00:00.000

I would like the minutes to come over as well and be 01JAN2014:08:28:00.000

Any way to get this to happen?

Re: INTNX Hours and Seconds

PGStats — Wed, 08 Jul 2020 17:22:12 GMT

You don't really need INTNX to do add or substract time to a datetime variable. You can respect SAS date and time conventions with time literals, like this:

nextFlightDate = flightDate + '08:00:00't;

Re: INTNX Hours and Seconds

BCNAV — Wed, 08 Jul 2020 18:21:28 GMT

You can also do:

intnx('seconds', t1.flightdate,28800)

Tough command to remember everything....thanks all!