Remote SQL Pass-Through (RSPT) Facility

SELECT... FROM CONNECTION TO Statement

Specifies which data will be used.

See:	SELECT statement in the SAS SQL Procedure User's Guide

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

object-item: specifies one or more columns or expressions. For more information, see the SELECT statement in the SAS SQL Procedure User's 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 the SELECT statement in the SAS SQL Procedure User's Guide.