topic Re: Intnx minus 1 day in SAS Programming

Intnx minus 1 day

darklord — Sun, 29 Jan 2023 17:50:16 GMT

Hello all!

Pretty lost here, im working on creating a dataset using proc sql with DATETIME() field being the start_date, and trying to make end_date using intnx function using the query below,

intnx('day', date time(), -1) as end_date format=datetime20.

DATETIME() field is already in DATETIME20. format, but the results show '.' for end_date when it finishes running.

Any idea what could be happening? The proc sql is built using a prebuilt proc sql table and one data table.

Thank you for the help!

Re: Intnx minus 1 day

PaigeMiller — Sun, 29 Jan 2023 17:56:49 GMT

I think you want this:

intnx('dtday', datetime(), -1) as end_date format=datetime20.

'DAY' works only on SAS date variables. 'DTDAY' works on SAS date/time variables. The DATETIME() function produces a date/time variable.

Please note in your original code, you have a space between date and time, that will never work.

Re: Intnx minus 1 day

darklord — Sun, 29 Jan 2023 18:20:08 GMT

Hello,
Thank you for the help! I suppose should have searched harder online, didn't come across this DTDAY function.
The output looks good now 🙂

Re: Intnx minus 1 day

PaigeMiller — Sun, 29 Jan 2023 18:27:35 GMT

So technically, DTDAY is an argument to the INTNX function

All possible intervals that you can use here: http://documentation.sas.com/doc/en/pgmmvacdc/9.4/leforinforref/n0pxq4af0hx60nn1i1x3xn41mc3c.htm#n0zn1re74n6pfvn170g9us41coho

Re: Intnx minus 1 day

darklord — Mon, 30 Jan 2023 13:45:45 GMT

Appreciate the link:)