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
RESET Statement
Resets PROC SQL options without restarting the procedure.
| See: | Combining Two Tables |
Syntax
RESET <option(s)>;
Required Argument
RESET
The RESET statement enables you to add, drop, or change the options in PROC SQL without restarting the procedure. For more information, see PROC SQL Statement for a description of the options.
Copyright © SAS Institute Inc. All rights reserved.