You can update one or more rows of a table through a view, with some restrictions. See Updating PROC SQL and SAS/ACCESS Views ... To add, drop, or modify a column's definition or attributes, use the ...

A common SQL habit is to use SELECT ... into production should request only the columns actually used. Something else developers do a lot is using UPDATE ... WHERE to set the value of one ...