The SQL procedure implements the Structured Query Language (SQL)
for SAS. See the
SAS SQL Procedure User's Guide for information
about PROC SQL. You can send data source-specific SQL statements directly
to a data source using an extension to the SQL procedure called the
pass-through facility.
This facility uses
SAS/ACCESS to connect to a data source and to send statements directly
to the data source for execution. This facility is a complement to
the
SAS/ACCESS LIBNAME statement. It enables you to use the SQL syntax
of your data source, which can include any non-ANSI standard SQL that
is supported by your data source.
Using the pass-through
facility, you can do the following:
-
Establish and terminate connections
with a data source using the CONNECT and DISCONNECT statement.
-
Send dynamic, non-query, data source-specific
SQL statements to a data source using the EXECUTE statement
EXECUTE Statement.
-
You can use pass-through
facility statements in a PROC SQL query, or you can store them in
a PROC SQL view. When you create a PROC SQL view, any arguments that
you specify in the CONNECT statement are stored with the view. Therefore,
when the view is used in a SAS program, SAS can establish the appropriate
connection to the data source.