Using INTNX in Proc SQL gives error

Peter_B — Fri, 22 Jun 2018 02:29:59 GMT

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

Re: Using INTNX in Proc SQL gives error

Kurt_Bremser — Fri, 22 Jun 2018 03:34:29 GMT

In an explicit pass-through, you need to use functions that the target database understands. intnx is not a function in Oracle SQL.

Peter_B — Fri, 22 Jun 2018 03:36:32 GMT

Ah, Of Course!

Thanks Kurt. : >