SAS Certification Prep Guide, 4th Edition

Updating PROC SQL Views

Overview

You can update the data underlying a PROC SQL view using the INSERT, DELETE, and UPDATE statements under the following conditions:

• You can update only a single table through a view. The table cannot be joined or linked to another table, nor can it contain a subquery.
• You can update a column using the column's alias, but you cannot update a derived column (a column that is produced by an expression).
• You can update a view that contains a WHERE clause. The WHERE clause can be specified in the UPDATE clause or in the view. You cannot update a view that contains any other clause such as an ORDER BY or a HAVING clause.
• You cannot update a summary view (a view that contains a GROUP BY clause).