Hi Forum,
I have a dataset that contains a Date Time field.
So I wrote a Proc SQL statement with the below WHERE Clause.
I want to use the 'INTNX' Function to match the Date Time to a MthYr value such as below:
WHERE intnx('month',datepart(c.DATETIME),0,'e') = 'MAY18'
ERROR: ORACLE prepare error: ORA-00904: "INTNX": invalid identifier
I'm getting an 'Invalid Identifier' Error.
However, if I add a query builder to the existing table and create an expression using the exact same statement, it works?
Can anyone advise why this is so & how I need to write the WHERE clause so it will run?
Thanks
In an explicit pass-through, you need to use functions that the target database understands. intnx is not a function in Oracle SQL.
In an explicit pass-through, you need to use functions that the target database understands. intnx is not a function in Oracle SQL.
Ah, Of Course!
Thanks Kurt. : >
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.