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;
You can't replace a data set in place afaik.
You can't replace a data set in place afaik.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.