Similar Posts

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

2 Comments

  1. Hi Subro
    your Blog is super for SAS beginners and experienced
    Could you please points for below interview question
    Q1.) What is the difference between implicit pass thru query and explicit pass thru query which is the best in terms of optimize the code and which functions are work for both?

  2. Hi Anand,
    In the implicit pass-thru, SAS automatically converts the SQL code so that that the database can understand. You will not be able to write SQL-specific functions using implicit pass-thru. In explicit pass-thru, you write the SQL query in the SQL dialect understood by the database. Generally, Explicit pass-thu is more optimized because you can write queries that are tailored to the specific database engine you are using, and you can use database-specific syntax and functions for better performance.