explicit pass through query is nothing but when we connect to the data base the query which hits the database and make the required modifications in the db and imports the data. Here the total execution takes place in db. when we code explicit pass through query the sas functions wont work. for example we are connecting to oracle we have to write oracle functions only. Proc sql; connect to oracle (user=XXX password=XXX); select * from connection to oracle (select * from table); disconnect from oracle; quit; in implicit pass through query the execution takes place in sas server itself and imports the data. proc sql; select * from table where condition; quit; or Libname libref "path"; ... View more