topic RROR: You cannot open WORK.NORMAL.DATA for output access with member-level control because WORK.NORM in All Things Community

RROR: You cannot open WORK.NORMAL.DATA for output access with member-level control because WORK.NORM

papaya21222 — Mon, 14 Nov 2016 02:54:52 GMT

Hello All,

Please help me for this. This is my program.

filename prtsort catalog 'Mysas.Mymacro';
%include prtsort(multnorm)/source2;
proc iml;
X={5 3 1 0.2,
3.9 3 1.4 5.2,
9.9 3.2 1.3 0.2};

varNames = "x1":"x4";
create Normal from X[c=varNames]; append from X; close Normal;
quit;

/* Tests for MV normality */
/* Tests for MV normality */
%inc "C:\Users\Desktop\dataMY Sas Files\Mysas.Mymacro\multnorm";
%multnorm(data=Normal, var=x1 x2 x3 x4, plot=MULT);

but I am getting an ERROR: RROR: "You cannot open WORK.NORMAL.DATA for output access with member-level control because
WORK.NORMAL.DATA is in use by you in resource environment DMS Process."

I cant understand the reason. Please help me to fix this.

Re: RROR: You cannot open WORK.NORMAL.DATA for output access with member-level control because WORK.

Ksharp — Mon, 14 Nov 2016 03:12:53 GMT

That says table NORMAL has already been open , you can't use it until it is closed.
Restart your SAS session and better reboot your computer to fix it .

Re: RROR: You cannot open WORK.NORMAL.DATA for output access with member-level control because WORK.

papaya21222 — Mon, 14 Nov 2016 03:32:15 GMT

Ksharp,

It works. Thank you very much !