topic Re: difference between sas libname statement and SAS sql pass through statement in SAS Programming

difference between sas libname statement and SAS sql pass through statement

arpit — Tue, 08 Mar 2011 16:16:21 GMT

Please explaine me how sas libname statement is defferent from SAS SQL passthrough statement and why sas sql pass through statement is more efficient than libname statement

For what reason we use sql pass through statement.

Re: difference between sas libname statement and SAS sql pass through statement

deleted_user — Tue, 08 Mar 2011 17:22:38 GMT

Hi Arpit,

f you use the LIBNAME Statement to connect to the database, you can choose either the DATA step or PROC SQL to process data. However, if you choose the Pass-Through Facility to talk with the database, PROC SQL is your only choice.

The Pass-Through Facility enables you to interact with a data source using its native SQL syntax without leaving your SAS session, a definite advantage.
and enables you to send DBMS-specific SQL statements directly to a DBMS for execution.

Thanks

Re: difference between sas libname statement and SAS sql pass through statement

arpit — Thu, 10 Mar 2011 05:07:05 GMT

Dear Raveenat,

Thanks a lot for your kind information.

Regards,
Bina