Modifies a column's values in existing rows of a table or view. Restriction: You cannot use UPDATE on a table accessed via an engine that does not support UPDATE processing. You can update one or more ...

Reading and Updating Data with the SQL Procedure In Version 6, the SAS System's SQL procedure enabled you to retrieve and update data from DBMS tables and views. You could read and display DBMS data ...

So I'm thinking CASE statements are the way to go (thinking as in I only query Oracle and never update it) along the line of this.