Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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 :