LIBNAME Statement and Pass-Through Facility for PC Files on Microsoft Windows

Syntax for the Pass-Through Facility for PC Files

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

PROC SQL <options-list>;
CONNECT TO <data-source-name> AS< alias> (<connect-statement-arguments> <database-connection-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 these 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 can be written to the SAS log using the %PUT macro. The contents are reset after each Pass-Through Facility statement is executed.

Example 1: Connect to an Excel 2007 .xlsx file and Query the INVOICE Table (range) within the Excel Workbook:

PROC SQL DQUOTE=ANSI;
CONNECT TO EXCEL (PATH='c:\sasdemo\sasdemo.xlsx');
SELECT * FROM CONNECTION TO EXCEL
   (SELECT * FROM INVOICE);
DISCONNECT FROM EXCEL; 
QUIT;

Top of Page