BookmarkSubscribeRSS Feed
nkm123
Calcite | Level 5

How do we know if implicit pass through haapened or not .. or if using LIBNAME enging then how do we know if processing haapened at DBMS side or SAS Side. Would there is only oprion is DEBUG = DEDUG_SELECT or there is any other way also. 

3 REPLIES 3
Reeza
Super User

Have you checked the MSGLEVEL option in the log?

nkm123
Calcite | Level 5

Hi Reeza, I don't see anything when turn on msglevel option.  when use DEBUG=DBMS_SELECT , I can see following message but only when use distinct in sql query. 

 

DEBUG: SQL Implicit Passthru stmt used for fetching data.
ACCESS ENGINE: SQL statement was passed to the DBMS for fetching data.

 

if same query runs without distinct , I don't see any message like this. so I am just trying to understand if implict pass through could even happen but message is not displayed. Is there any other way to know if implicit pass through happened or not apart from DEBUG=DBMS_SELECT options. 

Ksharp
Super User
options sastrace=',,,d' sastraceloc=saslog ;

Once you see the native sql translating into RDBMS sql in LOG.

then the SQL should be executed at DB side.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1195 views
  • 0 likes
  • 3 in conversation