The SQL Procedure

CONNECT Statement

Establishes a connection with a DBMS that SAS/ACCESS software. supports

Requirement:	SAS/ACCESS software is required. For more information about this statement, see your SAS/ACCESS documentation.
See also:	Connecting to a DBMS Using the SQL Procedure Pass-Through Facility in the SAS 9.2 SQL Procedure User's Guide

CONNECT TO dbms-name <AS alias>
<(connect-statement-argument-1=value <... connect-statement-argument-n=value>)>
<(database-connection-argument-1=value <... database-connection-argument-n=value>)>;

Arguments

alias: specifies an alias that has 1 to 32 characters. The keyword AS must precede alias. Some DBMSs allow more than one connection. The optional AS clause enables you to name the connections so that you can refer to them later.
connect-statement-argument=value: specifies values for arguments that indicate whether you can make multiple connections, shared or unique connections, and so on, to the database. These arguments are optional, but if they are included, then they must be enclosed in parentheses. See SAS/ACCESS for Relational Databases: Reference for more information about these arguments.
database-connection-argument=value: specifies values for the DBMS-specific arguments that are needed by PROC SQL in order to connect to the DBMS. These arguments are optional for most databases, but if they are included, then they must be enclosed in parentheses. For more information, see the SAS/ACCESS documentation for your DBMS.
dbms-name: identifies the DBMS that you want to connect to (for example, ORACLE or DB2).

Top of Page