SAS/SHARE -Lock Issue while updating same dataset with multiple process

jdveerapaneni — Wed, 02 Oct 2019 18:27:51 GMT

We have different process flows which will update the same dataset at the end of the each code .Some of these processes are overlapping with their run time and causing Lock Issues on dataset which is causing to fail the job.We have SAS/SHARE.I tried to use Modify ,set, Proc sql but nothing worked .Please let me know how this can work with out locking.

ex: code1:

Option DLCREATEDIR;
LIBNAME myshr_a BASE "/tmp/" ;
LIBNAME myshr_b REMOTE HOSTNAME="xxxxx" Server=__1111 slibref=myshr_a USER="&sysuid." PASSWORD="&syspass." ;

%let r=xxxx;
proc operate id=r.__1111 user="&sysuid." pass="&syspass.";
display library _all_; run;

libname myshr_r list ;

data myshr_b.sample;
modify myshr_b.sample(where =(table_id="abcd" and field_name="sam1" and table_update_dt=today()));
x=1234567;
y= 7654321 ;

replace;
run;

code2 :

data myshr_b.sample;
modify myshr_b.sample(where =(table_id="bcde" and field_name="sam2" and table_update_dt=today()));
x=1234567;
y= 7654321 ;

replace;
run;

both code1 and code2 runs at same time .sample dataset should be modified by both codes without Locking.

Re: SAS/SHARE -Lock Issue while updating same dataset with multiple process

Tom — Wed, 02 Oct 2019 18:43:27 GMT

Do you have an index defined for those three variables?

Without that the WHERE clause will need to access every observation sequentially to check if the WHERE condition is met. It might be that with an INDEX it can skip trying to read observations that do not meet the where condition.

Re: SAS/SHARE -Lock Issue while updating same dataset with multiple process

jdveerapaneni — Wed, 02 Oct 2019 20:09:15 GMT

Yes with INDEX it worked.Thanks so much 🙂

topic SAS/SHARE -Lock Issue while updating same dataset with multiple process in SAS Programming

SAS/SHARE -Lock Issue while updating same dataset with multiple process

Re: SAS/SHARE -Lock Issue while updating same dataset with multiple process

Re: SAS/SHARE -Lock Issue while updating same dataset with multiple process