SAS ENTERPRISE GUIDE OPENS DATA USING TABLE-LEVEL LOCKING

SAS modules addressed: Enterprise Guide, General Hints

Suggested by Sridevi Thoguluva Chandrasekaran at Cognizant Technology Solutions.

TSN-005370: SAS Enterprise Guide opens data using table-level locking.

An error similar to the following might occur in SAS Enterprise Guide when attempting to update a table using code that is opened in SAS Enterprise Guide in read only or update mode:

Error: You cannot open lib_name.

table_name.DATA for output access

with member-level control.



lib_name.table_name.DATA is in

use by you in resource environment

some_step.

An error similar to the following might occur in SAS when attempting to update a table using code that is opened in SAS Enterprise Guide in read only or update mode:

Error: A lock is not available for

lib_name.table_name.DATA, lock

held by another process.



Error: File lib_name.table_name.

DATA is not open.

If a table is opened in update mode (any table including SAS/SHARE), the table is opened with table-level locking. No other user or process can update or read the table while the table is opened in update mode.

If the table is opened in read/protected mode, then no other user or process can open the table in update mode. The table can only be shared by other users or processes in read mode. To try to circumvent the problem in SAS Enterprise Guide, use the Menu selection Window => Close All, then run the section of the project that did not complete.

Also try Tools => Options => SAS Programs => select ‘Close all open data before running code’.

To search for usage notes such as above please use the SASNOTES website: http://support.sas.com/techsup/search/sasnotes.html