The specified columns are dropped when the table is created. Indexes are not copied to the new table. Both of these forms create a table without rows. You can use an INSERT statement to add rows. Use ...

For example, let's say I'm updating 100 rows in a table. I'd like to know that a NULL is going to be inserted into a non-nullable field on one row via RAISEERROR, skip that row's update, and then ...

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