SQL procedure views are defined as non-updatable if more than 1 table is referenced within the view.

Upon creation, non-updatable PROC SQL views contain a column named Flags. You can see this column by submitting the CONTENTS procedure. The output for PROC CONTENTS is similar to the following output:

     -----Alphabetic List of Variables and Attributes-----

     #    Variable    Type    Len    Pos    Flags
     --------------------------------------------
     1    Name        Char      8      0    P--

'P' indicates a protected column that cannot be updated.

Most SAS procedures that use the OUT= option to create a new SAS table will propagate the Update Flag to the new SAS table. This action makes the new SAS table non-updatable.

If you attempt to update the SAS table, you will see the following warning in the SAS log:

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :