Difference between sas proc sql pass through facility and sql pass through facilty

Reply
Occasional Contributor
Posts: 12

Difference between sas proc sql pass through facility and sql pass through facilty

Hi,

 

Difference between sas proc sql pass through facility and sql pass through facilty

Grand Advisor
Posts: 17,462

Re: Difference between sas proc sql pass through facility and sql pass through facilty

There's no difference? Do you mean the difference between Proc SQL and pass through? 

 

 

Occasional Contributor
Posts: 18

Re: Difference between sas proc sql pass through facility and sql pass through facilty

Hi Ganesh,

 

Please go through this link to know the difference between implicit and explicit sql pass through:

 

http://support.sas.com/resources/papers/proceedings11/105-2011.pdf

 

Regards,

Sundeep

Occasional Contributor
Posts: 12

Re: Difference between sas proc sql pass through facility and sql pass through facilty

Thank You

##- Please type your reply above this line. Simple formatting, no
attachments. -##
Super Contributor
Posts: 336

Re: Difference between sas proc sql pass through facility and sql pass through facilty

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.

Valued Guide
Posts: 2,111

Re: Difference between sas proc sql pass through facility and sql pass through facilty

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.

Ask a Question
Discussion stats
  • 5 replies
  • 458 views
  • 2 likes
  • 5 in conversation