topic Re: Error SAS ERROR: You cannot open WORK.T.DATA for input access with record-level control because in New SAS User

Error SAS ERROR: You cannot open WORK.T.DATA for input access with record-level control because WORK

luciacossaro — Sat, 27 Oct 2018 09:07:45 GMT

Hi,

I've a message error and i don't find the cause, I think maybe it's some configuration. I'm doing a proc reg and i need to have the residuals in a dataset. But the first time i run the program the dataset 'prevrest' is not generated and the second time i run the program, i see the dataset in work librery but when i try to open i have the message of the picture.

I found here another post about the problem but the solution was 'restart' the pc and i tried that but the problem persists.

The problem is with SAS 9.4, I have executed exactly the same code in entreprise guide and that works fine.

Somebody could help me ?

Thanks very much !

Lucia

data house ; 
	set "D:\Users\lucia\Documentos\housing";
	prix_au_feet2 = price / lotsize ;
run ;

proc reg data=house ; 
	model price = lotsize bathrms ; 
	output out=prevrest p=prev r=res ; 
run ;

Re: Error SAS ERROR: You cannot open WORK.T.DATA for input access with record-level control because

Rick_SAS — Sat, 27 Oct 2018 11:06:46 GMT

PROC REG is an interactive procedure. That means that it does not exit when you execute a RUN statement. Instead, it remains running, waiting to see whether you are going to submit more statements.

The procedure has opened a data set for writing and the data set will remain open until you use a QUIT statement or execute a new procedure. Thus the solution is to put the statement

QUIT;

at the end of your program. That will close the data set.

Re: Error SAS ERROR: You cannot open WORK.T.DATA for input access with record-level control because

Jagadishkatam — Sat, 27 Oct 2018 10:47:12 GMT

Try running it in a fresh session.

To clear any file which is opened, you could try the code below. Run this code to close any open file and then run your code.

%macro close_all_dsid;
  %local i rc;
  %do i=1 %to 1000;
    %let rc=%sysfunc(close(&i));
  %end;
%mend;
%close_all_dsid;

Re: Error SAS ERROR: You cannot open WORK.T.DATA for input access with record-level control because

Ksharp — Sat, 27 Oct 2018 10:55:21 GMT

Rename it .

proc reg data=house ; 
	model price = lotsize bathrms ; 
	output out=prevrest_whatever p=prev r=res ; 
run ;

Re: Error SAS ERROR: You cannot open WORK.T.DATA for input access with record-level control because

luciacossaro — Sat, 27 Oct 2018 11:43:02 GMT

Thanks you, that was the problem, now it's work fine.

I don't understad why thant happens with sas 9.4 and not with entreprise guide.

Re: Error SAS ERROR: You cannot open WORK.T.DATA for input access with record-level control because

Rick_SAS — Sat, 27 Oct 2018 11:56:42 GMT

Because EG automatically appends a QUIT statement to the end of the SAS code that it submits.

Re: Error SAS ERROR: You cannot open WORK.T.DATA for input access with record-level control because

Doug____ — Wed, 29 Apr 2020 19:39:54 GMT

What other steps do you recommend if the quit statement is present yet the error still appears when executing SQL?

Re: Error SAS ERROR: You cannot open WORK.T.DATA for input access with record-level control because

Rick_SAS — Wed, 29 Apr 2020 19:46:17 GMT

I recommend that you start a new thread and show the code you are using and the log that contains the error.