topic Re: A lock is not available for STAGING.BASE in SAS Programming

A lock is not available for STAGING.BASE

langalife — Wed, 17 Mar 2021 10:58:27 GMT

Good day

I have several programs in a batch my aim is to run them at the same time, all these programs are writing to the same dataset however one or two write successfully other fails because of a lock is not available for STAGING.BASE

I researched and get filelockwait but did not work,

libname staging '/sas/prd/mrad/mrd7mdlintu/projects/langanat/rbc_data_quality/sasdata/staging' filelockwait=300;

I also got %macro trylock but I don't know how to use it.

So I kindly need help to be able to tell programs to wait for other programs to finish loading before they start loading to staging.base.

Thanking you in-advance.

regards

Langalife

Re: A lock is not available for STAGING.BASE

Kurt_Bremser — Wed, 17 Mar 2021 11:18:24 GMT

You do that in a scheduler by setting appropriate conditions.

Or you create a master script that runs all programs in succession.

Re: A lock is not available for STAGING.BASE

Sajid01 — Wed, 17 Mar 2021 12:05:32 GMT

A simple approach will be for each of the process to write to its own dataset.
Later a batch process can append all of those individual datasets into the desired dataset.

As an alternative explore using SAS SHARE or writing to an RDBMS database.