SQL Procedure
- Syntax
Procedure SyntaxPROC SQL StatementALTER TABLE StatementCONNECT StatementCREATE INDEX StatementCREATE TABLE StatementCREATE VIEW StatementDELETE StatementDESCRIBE StatementDISCONNECT StatementDROP StatementEXECUTE StatementINSERT StatementRESET StatementSELECT StatementUPDATE StatementVALIDATE Statement - Overview
- Examples Creating a Table and Inserting Data into ItCreating a Table from a Query's ResultUpdating Data in a PROC SQL TableJoining Two TablesCombining Two TablesReporting from DICTIONARY TablesPerforming an Outer JoinCreating a View from a Query's Result Joining Three TablesQuerying an In-Line View Retrieving Values with the SOUNDS-LIKE Operator Joining Two Tables and Calculating a New ValueProducing All the Possible Combinations of the Values in a ColumnMatching Case Rows and Control RowsCounting Missing Values with a SAS Macro
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: | Connecting to a DBMS by Using the SQL Procedure Pass-Through Facility |
Syntax
<(connect-statement-argument-1=value <… connect-statement-argument-n=value>)>
<(database-connection-argument-1=value <… database-connection-argument-n=value>)>;
Required 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).
libname
specifies the LIBNAME where a DBMS connection has already been established. The LIBNAME can be reused in the SQL procedure using the CONNECT statement.