functions in pass thru query

[pavank]

Hi Experts,

I have a question regarding data step and pass thru query difference which functions are not working in pass thru query compare to data step ? 

[Patrick]

For implicit pass-through: Which functions SAS can convert to database syntax is fully documented per access engine (like for SAS Access to Oracle). Look it up.

For explicit pass-through: Because SAS sends the syntax as-is to the database you need to use database functions in your code. The SAS functions are obviously not available.