In clause oroc sql

Regular type indicates the name of a component that is described in SQL Procedure Component Dictionary.

view-name indicates a SAS view of any type.

Table of Contents: The SQL Procedure ALTER TABLE table-name
< ADD constraint-clause >
CREATE < UNIQUE >INDEX index-name
ON table-name ( column );
CREATE TABLE table-name
( column-specification )
CREATE TABLE table-name LIKE table-name2 ;
CREATE TABLE table-name AS query-expression
CREATE VIEW proc-sql-view AS query-expression
FROM table-name|proc-sql-view |sas/access-view
DESCRIBE TABLE table-name ;
DESCRIBE VIEW proc-sql-view ;
DESCRIBE TABLE CONSTRAINTS table-name ;
DROP INDEX index-name
FROM table-name ;
DROP TABLE table-name ;
DROP VIEW view-name ;
INSERT INTO table-name|sas/access-view|proc-sql-view <( column <, . column >)>
SET column =sql-expression
INSERT INTO table-name|sas/access-view|proc-sql-view <( column <, . column >)>
VALUES ( value )
<. VALUES ( value )>;
INSERT INTO table-name | sas/access-view|proc-sql-view
<( column <, . column >)> query-expression;