BookmarkSubscribeRSS Feed
arpit
Calcite | Level 5
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.
2 REPLIES 2
deleted_user
Not applicable
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
arpit
Calcite | Level 5
Dear Raveenat,

Thanks a lot for your kind information.

Regards,
Bina

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 5360 views
  • 0 likes
  • 2 in conversation