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...
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.