SAS functions executed in SAS or Hadoop

techie — Mon, 05 Apr 2021 07:34:27 GMT

Hi Fellow SAS Communities,

Is there a way we can find out a SAS function(s) has been executed in SAS or Hadoop.

TIA

Re: SAS functions executed in SAS or Hadoop

JBailey — Tue, 06 Apr 2021 13:47:11 GMT

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

topic Re: SAS functions executed in SAS or Hadoop in SAS Programming

SAS functions executed in SAS or Hadoop

Re: SAS functions executed in SAS or Hadoop