DATA Step, Macro, Functions and more

Dataset getting locked mysteriously

Posts: 35

Dataset getting locked mysteriously

Hi all,

I am facing an weird problem. I am creating a table from one process (sas session) and trying to delete that same table using a second process (sas session). These sas sessions are getting called using Java from interface.

Now in the second process when I am trying to delete the dataset it is telling that ERROR: Delete lock is not available for TMPLIB.SPOT_STATUS.DATA, lock held by another process.

But we are not locking this table in anywhere. The code used for deletion is:


     proc datasets library=tmplib;

     delete spot_status;


Could you please suggest a solution. Is it possible that some external process is locking the table and if yes then is there a way to track that process?

Thanks in advance for your help.

Thanks & Regards,

Saugata Mukherjee.

Valued Guide
Posts: 2,191

Dataset getting locked mysteriously

how  do you ensure the creation is complete (and table closed) before second session attempts the delete?

Trusted Advisor
Posts: 1,318

Dataset getting locked mysteriously

What library engine is being used?

There are a number of ways in which to avoid this error and have a program wait for a lock to become available.

Here is one example paper that outlines a macro call %trylock

Play Nice with Others: Waiting for a Lock on SAS Table

Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation