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;