Remote SQL Pass-Through (RSPT) Facility

SELECT... FROM CONNECTION TO Statement

Specifies which data will be used.
See also:	SELECT Statement in the Base SAS Procedures Guide

SELECT object-item FROM CONNECTION TO server (dbms-select-expression);

Syntax Description

object-item

specifies one or more columns or expressions. For more information, see SELECT Statement in the Base SAS Procedures Guide.

server

specifies the SAS SQL server or server DBMS where the data is stored. Here are the valid values for server:

REMOTE: the server that is specified in the most recent CONNECT TO REMOTE statement will be used.
alias: the server that you assigned the alias to (in the AS=alias option in the CONNECT TO REMOTE statement) will be used. Specifying alias is useful if you are connected to several SQL servers at the same time.

dbms-select-expression

specifies a SELECT expression that will be processed before the data is transmitted. For server data that is accessed through the PROC SQL view engine, dbms-select-expression is any valid PROC SQL SELECT statement. For a server DBMS, dbms-select-expression is the same SQL query that you would specify if you were connected directly to the DBMS. For more information about the PROC SQL SELECT statement, see SELECT Statement in the Base SAS Procedures Guide.

Top of Page