Updating Values in Existing Table Rows

Overview

To modify data values in some or all of the existing rows in a table, you use the UPDATE statement in PROC SQL. In the UPDATE statement, for each column whose rows you want to modify, you specify an expression that indicates how the values should be modified. For example, the following expression indicates that the values for the column Units should be multiplied by 4: 
units=units*4
You can use the UPDATE statement in two main ways.
Method of Updating Table
Example
update all (or a subset of) rows in a column with the same expression 
proc sql;
   update work.payrollmaster_new
      set salary=salary*1.05
      where jobcode like '__1';
update different rows in a column with different expressions ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial