topic Re: ERROR: A lock is not available for in New SAS User

ERROR: A lock is not available for

SASPhile — Thu, 04 Oct 2018 21:01:40 GMT

I'm getting the error "ERROR: A lock is not available for". I closed the session and re-started , yet this error comes. I'm using windows environment and submitting batch jobs.

Re: ERROR: A lock is not available for

Astounding — Thu, 04 Oct 2018 21:25:13 GMT

The typical scenario: it takes patience.

One batch job is using the data set, while another batch job wants to use the data set. If one of the batch jobs wants to change the data set (for example, running PROC SORT on a permanent SAS data set), it is not possible for both batch jobs to access the data set at the same time.

Your programming style can have some impact here. For example, if you add OUT= to your PROC SORT, then that step doesn't need to tie up the data set. But in a large number of cases, patience is a virtue.

Re: ERROR: A lock is not available for

SASPhile — Thu, 04 Oct 2018 22:06:49 GMT

1. How to know what processes are running?

2. How to kill the processes on windows?

Re: ERROR: A lock is not available for

Astounding — Thu, 04 Oct 2018 23:19:31 GMT

Sorry, I don't have answers for that on Windows.

Re: ERROR: A lock is not available for

Kurt_Bremser — Fri, 05 Oct 2018 06:05:18 GMT

@SASPhile wrote:

1. How to know what processes are running?

2. How to kill the processes on windows?

If you want to make your life easier, can the toybox and switch to a real operating system. At the moment, this means UNIX.

I work on a UNIX platform, and on such this is a non-issue, as I can easily remove links to files (aka "directory entries") from the filesystem while a process is still using the file. That is because UNIX systems have a different concept of filesystem structure that is lightyears ahead of the much-too-simple method that Windows has.