A lock is not available for STAGING.BASE

[langalife]

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

[Kurt_Bremser]

You do that in a scheduler by setting appropriate conditions.

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

[Sajid01]

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.