If you specify READ_MODE_WAIT=NO
and if a different user holds a restrictive lock, the executing SAS
step fails.
SAS/ACCESS continues processing the job by executing the
next step.
If you specify READ_MODE_WAIT=YES,
SAS/ACCESS waits indefinitely until it can acquire the lock.
A
restrictive lock
means that another user is holding a lock that prevents you from obtaining
the lock that you want. Until the other user releases the restrictive
lock, you cannot obtain your lock. For example, another user's table-level
WRITE lock prevents you from obtaining a READ lock on the table.