Additional Features

In addition to the SELECT statement, PROC SQL supports the following statements.
Statement
Use to ...
ALTER TABLE expression;
add, drop, and modify columns in a table
CREATE expression;
build new tables, views, or indexes
DELETE expression;
eliminate unwanted rows from a table or view
DESCRIBE expression;
display table and view attributes
DROP expression;
eliminate entire tables, views, or indexes
INSERT expression
add rows of data to tables or views
RESET <option(s)>;
add to or change PROC SQL options without re-invoking the procedure
UPDATE expression;
modify data values in existing rows of a table or view
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.144.91.24