topic Re: SAS locks dataset for no reason in SAS Programming

SAS locks dataset for no reason

kashlik123 — Tue, 10 Aug 2021 13:00:36 GMT

I am trying to do a bootstrap sample of variables in a macro do loop. The code is similar to the macro shown below (NOTE: the code below works fine. It is the real dataset, which I cannot share here, where the problem occurs):

%Macro test();
	%Do x = 1 %to 10;
		data cars;
		set sashelp.cars;
		run;

		Proc surveyselect
		Data=cars
		Method=urs
		Seed=90
		Samprate=0.5
		Reps=100
		Out=cars_sample;
		Run;

	/*Do something with the sample for each iteration*/
	%End;
%Mend;

On the second iteration SAS tell me that the dataset is locked:

ERROR: You cannot open WORK.CARS_SAMPLE.DATA for output access with member-level control because WORK.CARS_SAMPLE.DATA is in use 
by you in resource environment IOM ROOT COMP ENV.

The dataset is certainly not open by any other user (this is confirmed because when I close SAS and start the session again the dataset unlocks), neither is it open by me in any other program.

How can I solve this issue?

Re: SAS locks dataset for no reason

Kurt_Bremser — Tue, 10 Aug 2021 13:58:38 GMT

Set Enterprise Guide to not automatically open result datasets for viewing.

Re: SAS locks dataset for no reason

kashlik123 — Tue, 10 Aug 2021 14:08:44 GMT

Do you mean tools - options - data general - Automatically import data when added to project? Or something else?

Re: SAS locks dataset for no reason

Kurt_Bremser — Tue, 10 Aug 2021 14:39:16 GMT

It is in Tools - Options - Results General - automatically open Data or Results (rough translation, my EG 7.15 is set to German)

Re: SAS locks dataset for no reason

kashlik123 — Tue, 10 Aug 2021 14:47:40 GMT

My version is 8.1 and there is no such option

Re: SAS locks dataset for no reason

jimbarbour — Tue, 10 Aug 2021 14:55:56 GMT

If you are using EG 8, it would look something like the below.

Jim

Re: SAS locks dataset for no reason

kashlik123 — Tue, 10 Aug 2021 16:20:40 GMT

Thank for the reply, but unfortunately it does not work

Re: SAS locks dataset for no reason

Reeza — Tue, 10 Aug 2021 16:42:41 GMT

It could be in the rest of your code. Without the full code and log not sure we can actually answer this.

Re: SAS locks dataset for no reason

Reeza — Tue, 10 Aug 2021 16:43:08 GMT

And make sure to restart EG between the change and test.

Re: SAS locks dataset for no reason

Tom — Tue, 10 Aug 2021 17:35:51 GMT

Try making a different dataset each time through the loop.

%do x = 1 %to 10;
...
  Out=cars_sample&x
...

Re: SAS locks dataset for no reason

ballardw — Tue, 10 Aug 2021 17:46:48 GMT

An aside, when you use a specific seed value in Proc Surveyselect with the same input data set and other options/parameters the resulting data is exactly the same. So running that particular Surveyselect code generates the same data set 10 times.

I know you are saying "like this" but if the code is close enough to the example there is a certain amount of repeating the same thing for the exact same sample.

And the likely issue is in the

/*Do something with the sample for each iteration*/

Possibly one of the procedures like Proc Datasets or Document that expects a Quit statement to end the procedure.