Techie Tip: How to Instruct SAS Enterprise
Guide To Use Code to Update a Table
By Sridevi Chandrasekaran
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.
Similarly, an error such as the
following might occur 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.
|
