intnx is a SAS function that is why. You have to remember that SQL in a proc SQL when run locally is using the inbuilt SAS SQL compiler, which has access to the SAS functions. If you are passing through the SQL code, then that code is taken as test to the database SQL compiler and run there, the SQL parser will not have the SAS functions. Therefore you need to build your SQL using the destination platform, so if it is the database, then you would need to use the database functions to perform such a test, or write it yourself.
... View more