In some SAS/ACCESS interfaces, you can issue an EXECUTE statement directly without first explicitly connecting to a DBMS (see CONNECT Statement). If you omit the CONNECT statement, an implicit ...

Learn the benefits and drawbacks of using proc sql for complex joins and aggregations in SAS. Compare proc sql with data steps and SQL pass-through.

However, because the SQL Procedure Pass-Through Facility uses a SAS/ACCESS engine to connect to the DBMS, you must have SAS/ACCESS software in order to use it. You specify DBMS syntax instead of SAS ...