functions in pass thru query

pavank — Sun, 07 Apr 2024 05:00:59 GMT

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 ?

Re: functions in pass thru query

Patrick — Sun, 07 Apr 2024 05:07:23 GMT

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.

topic functions in pass thru query in SAS Programming

functions in pass thru query

Re: functions in pass thru query