Issue 27 - June 2007 - SAS UK - In The Know - Enewsletter

SAS Enterprise Guide opens data using table-level locking

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

Click here to visit www.sas.com/uk