Lock created on dataset

Reply
Occasional Contributor
Posts: 6

Lock created on dataset

I am running a SAS DI join transformation that is supposed to replace an existing dataset with an updated version.

The problem is that every time I run this transformation, I get this error message:

Error: A lock is not available for libname.dataset.

Error: Lock held by process 9558.

I have checked and none of my collegues was using the dataset so the lock is not due to someone else having the dataset open.

Any help with this would be greatly appreciated.

The code that is trying to run is this:

proc datasets lib = target nolist mowarn memtype = (dataview);

delete dataset;

run;

(I get the error here on the log)

proc sql;

create table target.dataset as

select

dataset.MNI length = 8,

dataset.birth_dt length = 8.,

dataset.create_dt length = 8.,

dataset.create_tm length = 8.,

cat(strip(previous_data.first_name), strip(previous_data.last_name), strip(previous_dataset.birth_dt)) as dataset.SLK length 36

from

source.dataset as dataset

;

(A warning here on the log: Warning: Data set target.dataset was not replaced because of NOREPLACE option and a repeat of the error here on the log)

quit;

Ask a Question
Discussion stats
  • 0 replies
  • 173 views
  • 0 likes
  • 1 in conversation