08-05-2016 12:00 AM
Please go through this link to know the difference between implicit and explicit sql pass through:
08-05-2016 01:16 AM
If you use implicit pass through you can treat database views or synonyms as if they were SAS data files and can use "SAS-SQL". If you use explicit pass through, you have to use for example "SQL(=Microsoft)-SQL". I sometimes use explicit pass through to deal for example with variable names that are longer than SAS's 32 characters. I don't think explicit pass through is faster than implicit pt.
08-05-2016 02:36 PM
user24feb mentions implicit pass thru as being the same speed as explicit.
Sometimes yes and sometimes no.
Implicit pass thru is when you write the SQL code in SAS SQL. The PROC SQL will interpret the code and, if possible, pass the entire thing to the host database server for processing. In that case the speed is the same. If PROC SQL cannot translate the code (usually you have used a SAS function that does not have an equivalent in the database SQL), SAS may grab all the tables from the data base server and bring them over to the SAS server for processing. With large tables, this can take a LOT more time.
The PROC SQL documentation shows how you can display the code that is actually sent to the database server.