Updating PROC SQL Views


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).

Get SAS Certification Prep Guide, 4th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.