Hi Russell, When you use the LIBNAME in your SQL code you are not doing explicit pass-thru. I don't have MySQL specific code but you can see the differences with this Teradata example. /* Notice this code does not use a LIBNAME statement */ PROC SQL; CONNECT TO TERADATA (SERVER=myTera USER=myUser PASSWORD=myPasswd); /* Everything in the () is sent directly to the database */ SELECT * FROM CONNECTION TO TERADATA (select * from eecdata.order_fact a , eecdata.order_fact)); DISCONNECT FROM TERADATA; QUIT; Here are some slides that explain it. If you want to force this to happen using Implicit Pass-Thru you can do that using the DBIDIRECTEXEC option. Here is an example, unfortunately it is Teradata. The assumption here is that I created the tera1 library using a LIBNAME statement. You probably know this, but others may not. You can get SAS to display the SQL being passed to the database using the following option. The SQL will be written to the SAS log. OPTIONS SASTRACE=',,,d' SASTRACELOC=saslog NOSTSUFFIX; Hopefully this will get you on the right track. If you need MySQL specific examples, let me know. Best wishes, Jeff
... View more