Hi @techie
In order for a SAS function to be passed down to a database it must be passed down to the database. The following SAS statement will display the SQL that is sending to the database:
OPTIONS SASTRACE=',,,d' SASTRACELOC=SASLOG NOSTSUFFIX;
You can see an example of it in this SGF workshop I delivered. It is old, but most of it is still relevant.
https://github.com/Jeff-Bailey/SGF2016_SAS3880_Insiders_Guide_Hadoop_HOW
Best wishes,
Jeff