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!
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.
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.
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...
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.