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
DROP Statement
Deletes tables, views, or indexes.
| Restriction: | You cannot use DROP TABLE or DROP INDEX on a table that is accessed by an engine that does not support UPDATE processing. |
Syntax
FROM table-name;
Required Arguments
index-name
specifies an index that exists on table-name.
table-name
specifies a PROC SQL table. table-name can be a one-level name, a two-level libref.table name, or a physical pathname that is enclosed in single quotation marks.
view-name
specifies a SAS view of any type: PROC SQL view, SAS/ACCESS view, or DATA step view. view-name can be a one-level name, a two-level libref.view name, or a physical pathname that is enclosed in single quotation marks.