
Details
You can update one or more rows of a table through a view, with some restrictions. See
“Updating PROC SQL and SAS/ACCESS Views” on page 173.
• Any column that is not modified retains its original values, except in certain queries
using the CASE expression. See “CASE Expression” on page 318 for a description
of CASE expressions.
• To add, drop, or modify a column’s definition or attributes, use the ALTER TABLE
statement, described in “ALTER TABLE Statement” on page 231.
• In the SET clause, a column reference on the left side of the equal sign can also
appear as part of the expression on the right side of the equal sign. For example, you ...