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 ... use the ...