topic Way of catch dataset is opened or not. in SAS Programming

Way of catch dataset is opened or not.

t_ar_taat — Sun, 16 Oct 2016 03:43:00 GMT

Is there any way that I can determine whether the dataset is open or not?

For example, If I open the dataset "x" in the work library,which means there is a window which title bar is "VIEWTABLE: work.X".
In this situation,I exist below code

data work.x;
yy = 1;
run;

There's a ERROR log saying "member-level control" etc., you know.

To avoid this, I'm looking for a way to grasp how this data set is open before casting the dataset(work.x) to DATA step.

I know "open" function,which is for open dataset.This time I'm looking "opened" or not.

I asked “Google” but it seems no answer.

Sincerely,

Re: Way of catch dataset is opened or not.

Reeza — Sun, 16 Oct 2016 04:56:51 GMT

The first paper in your google search is appplicable isn't it?

Try to open/lock the file and you'all get an error code if file is already opened.

The FOPEN function()

Re: Way of catch dataset is opened or not.

Patrick — Sun, 16 Oct 2016 06:17:09 GMT

In case you've started looking into this because you have some sort of a control/log table where multiple processes insert or update in parallel (so only short lock of the table per process) then have also a look into option FileLockWait as this will make the locking issue "go away" for such use cases.

Re: Way of catch dataset is opened or not.

t_ar_taat — Sun, 16 Oct 2016 07:34:33 GMT

Reeza,Thank you for your kindness every time.

Oops,actually if "open" function returns error,it means the dataset is opened.Thanks.

Re: Way of catch dataset is opened or not.

t_ar_taat — Sun, 16 Oct 2016 07:38:07 GMT

Thank you,Patrick.
I haven't seen "FILELOCKWAIT" System Option,so I'll check it.