Run 2 sas sessions related to a permanent data set

[Ronein]

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)?

[LinusH · Accepted solution]

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.

[yabwon]

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

[Kurt_Bremser]

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