topic Re: ERROR: Data set WORK.TAJ is already open for output. in SAS Global Forum Discussion

ERROR: Data set WORK.TAJ is already open for output.

Tracy29 — Wed, 15 Jun 2022 22:28:45 GMT

When I run SAS macro code, I get the error "Data set WORK.TAJ is already open for output."

Why that could happen?

Re: ERROR: Data set WORK.TAJ is already open for output.

Kurt_Bremser — Wed, 15 Jun 2022 19:24:03 GMT

@Tracy29 wrote:

When I run SAS macro code, I get the error "Data set WORK.TAJ is already open for output."

Why is that could happen?

No idea. Posting the ERROR on its own without the code that caused it tells us exactly nothing.

Please post the code you ran successfully before you tried to make it dynamic with a macro. If you do not have such code, you violated rule #1 of macro development: start with working non-macro code.

Re: ERROR: Data set WORK.TAJ is already open for output.

Reeza — Wed, 15 Jun 2022 19:53:43 GMT

Do you have the TAJ table open and viewed?

Usually that's why. Ensure the table is closed before running the macro again.

Re: ERROR: Data set WORK.TAJ is already open for output.

DrAbhijeetSafai — Mon, 22 Apr 2024 10:22:55 GMT

I found that I had given name of same dataset in the data statement. After correcting that, this error got resolved.

My programme was something like:

data TAJ TAJ;
     set indata;
run;

I corrected it to:

data TAJ;
     set indata;
run;

Thank you.

- Dr. Abhijeet Safai