topic Re: Run 2 sas sessions related to a permanent data set in SAS Programming

Run 2 sas sessions related to a permanent data set

Ronein — Wed, 18 Jun 2025 08:40:16 GMT

Hello

Lets say I have 2 SAS sessions that are open.

Lets say that in one sas session I update a permanent data set that is saved in a permanent library.

Lets say that in second sas session I am using this permanent data set (So I am using this data set but I dont update this data set).

My question-

Is it possible to update data set in one sas session and use this dats set in another sas session (Run both sas sessions in same time)?

Re: Run 2 sas sessions related to a permanent data set

LinusH — Wed, 18 Jun 2025 09:04:44 GMT

Quick answer - no.
The update operation will put a write lock on the data set.
You can use the FILELOCKWAIT option if your update is fairly quick and don't want your programs to abend.
Other options for you is to use SAS/SHARE (9.4 only), SAS SPD Server or store the data in an external database.

Re: Run 2 sas sessions related to a permanent data set

yabwon — Wed, 18 Jun 2025 09:23:16 GMT

Here are some interesting readings on solving "files locking" problem:

1) https://www.lexjansen.com/wuss/2014/69_Final_Paper_PDF.pdf

2) https://www.lexjansen.com/wuss/2015/60_Final_Paper_PDF.pdf

3) https://mwsug.org/proceedings/2016/BB/MWSUG-2016-BB31.pdf

Bart

Re: Run 2 sas sessions related to a permanent data set

Kurt_Bremser — Wed, 18 Jun 2025 12:43:57 GMT

For updating the dataset, see the last of my footnotes.