topic Re: how to reuse a table in the same session? in SAS Programming

how to reuse a table in the same session?

nnl3256 — Tue, 08 Jan 2019 17:24:03 GMT

There is data step and a table named fname is created. It is used in a macro. At end of the macro table is closed. When I rerun data step with modification in the same session, the table cannot be accessed. The error message: "ERROR: You cannot open WORK.FNAME.DATA for output access with member-level control because WORK.FNAME.DATA is in use by you in resource environment DMS Process." How can I re-use this table after the macro is completed? SAS code: data fname ; length id $2 name $10; input id $1-2 name $4-14; cards; aa TJC ;; run; %macro loopthrulst(list=); %let id=%sysfunc(open(&list)); %let NObs=%sysfunc(attrn(&id,NOBS)); %syscall set(id); %do i=1 %to &NObs; %let rc=%sysfunc(fetchobs(&id,&i)); %put # # # Display ORG name:&name # # #; %end; %let rc2=sysfunc(close(&id)); %mend; %loopthrulst(list=fname);

Re: how to reuse a table in the same session?

ballardw — Tue, 08 Jan 2019 17:43:07 GMT

The error message you show typically means that you have some sort of view of the data set open. Either the data portion in VIEWTABLE or perhaps the column or properties view. That will need to be closed before other use. The "DMS Process" mentioned is the SAS Display Manager or the "Base SAS" or "Foundation SAS" program. If the data set is open that will cause the Open function to fail and return the error message.

Your code will be more readable if you copy from the SAS editor and paste into a code box opened with either the {I} or "running man" icon.

Re: how to reuse a table in the same session?

Reeza — Tue, 08 Jan 2019 18:01:57 GMT

Formatting your code and question so we can properly read it is very helpful.

You're misisng the % on the last SYSFUNC call.

This works for me, note I changed ID to DSID to avoid any confusion between the ID variable and the ID macro variable.

data fname;
	length id $2 name $10;
	input id $1-2 name $4-14;
	cards;
 aa TJC 
;;
run;


options mprint symbolgen;
%macro loopthrulst(list=);

	%let dsid=%sysfunc(open(&list));
	%let nobs = %sysfunc(attrn(&dsid, NOBS));

	%syscall set(dsid);

	%do i=1 %to &nobs;
	  %let rc = %sysfunc(fetchobs(&dsid, &i));
	   %put # # # Display ORG name: &name # # #; 
    %end;
	%let rc2=%sysfunc(close(&dsid));


%mend;

%loopthrulst(list=fname);

@nnl3256 wrote:
There is data step and a table named fname is created. It is used in a macro. At end of the macro table is closed. When I rerun data step with modification in the same session, the table cannot be accessed. The error message: "ERROR: You cannot open WORK.FNAME.DATA for output access with member-level control because WORK.FNAME.DATA is in use by you in resource environment DMS Process." How can I re-use this table after the macro is completed? SAS code: data fname ; length id $2 name $10; input id $1-2 name $4-14; cards; aa TJC ;; run; %macro loopthrulst(list=); %let id=%sysfunc(open(&list)); %let NObs=%sysfunc(attrn(&id,NOBS)); %syscall set(id); %do i=1 %to &NObs; %let rc=%sysfunc(fetchobs(&id,&i)); %put # # # Display ORG name:&name # # #; %end; %let rc2=sysfunc(close(&id)); %mend; %loopthrulst(list=fname);

Re: how to reuse a table in the same session?

nnl3256 — Tue, 08 Jan 2019 18:50:09 GMT

It works by adding missing %. Thanks