Pass-Through Facility: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows

Syntax for the Pass-Through Facility for PC Files

This section contains syntax for the Pass-Through Facility statements and the CONNECTION TO component. You can use the component with the PROC SQL SELECT statement to query data from a data source.

PROC SQL <option(s)>;

CONNECT TO <data-source-name> AS <alias> (<CONNECTstatement-arguments><DATABASEconnection-arguments)>
DISCONNECT FROM<data-source-name|alias>
EXECUTE< (data-source-specific-SQL-statement)> BY <data-source-name>|<alias>
SELECT <column-list> FROM CONNECTION TO <data-source-name>|<alias (data-source-query)>

Return Codes

As you use the PROC SQL statements that are available in the Pass-Through Facility, any error conditions are written to the SAS log. The Pass-Through Facility generates return codes and messages that are available to you through the following two SAS macro variables:

SQLXRC: contains the data source return code that identifies the data source error.
SQLXMSG: contains descriptive information about the data source error that is generated by the data source.

The contents of the SQLXRC and SQLXMSG macro variables are printed in the SAS log using the %PUT macro. They are reset after each Pass-Through Facility statement has been executed.

Top of Page