Intnx minus 1 day

[darklord]

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!

[PaigeMiller · Accepted solution]

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.

[darklord]

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 🙂

[PaigeMiller]

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#n0z...

[darklord]

Appreciate the link:)