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
SELECT Statement
Selects columns and rows of data from tables and views.
| Restriction: | The clauses in the SELECT statement must appear in the order shown. |
| See: | SQL SELECT Statement Clauses |
| table-expression | |
| query-expression |
Copyright © SAS Institute Inc. All rights reserved.