Proc DS2 overwrite not working when used with circular/recursive set statement

[binary]

The following fails with the errors:

ERROR: Compilation error.
ERROR: Base table or view already exists A
ERROR: Unable to execute CREATE TABLE statement for table work.A.

is there a way to iterate on the same data like you can in a normal data step?  I've got a process using macros where I do this that ends up being CPU bound I'd like to try threading but I need to be able to keep passing the same dataset back to the set (then replace, then set again...). The use case I'm going for is by group aggregation across thousands of columns.

proc ds2;
data A(overwrite=yes);
method run();
set A(overwrite=yes);
end;
enddata;
run;
quit;

[ChrisNZ · Accepted solution]

You can't replace a data set in place afaik.