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

binary — Wed, 10 Feb 2021 05:25:05 GMT

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;

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

ChrisNZ — Wed, 10 Feb 2021 08:52:35 GMT

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

topic Re: Proc DS2 overwrite not working when used with circular/recursive set statement in SAS Programming

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

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