If you omit the WHERE clause, all the rows are updated. When you use a WHERE clause, only the rows that meet the WHERE condition are updated. When you update a column and an index has been defined for ...

Note: If you specify the NUMBER option in the PROC SQL statement when you create your view, the ROW column appears in the output. However, you cannot order by the ROW column in subsequent queries. See ...