You can update one or more rows of a table through a view, with some restrictions. See Updating PROC SQL and SAS/ACCESS Views. Any column that is not modified retains its original values, except in ...

A common SQL habit is to use SELECT * on a query ... For instance, if you insert data into a table and then use UPDATE to change it, like I’ve just shown, that’s two separate transactions.