@iscgonzalez wrote:
Hello,
I have a program that contains multiple proc sql on macros, something like this:
%macro m1000();
proc sql;
create table m1000 as
select * from test1000;
run;
%mend;
I have around 70 macros like this and my question is, how could I run those 70 macros having 5 processes in parallel at the same time to run them (like a queue with only 5 threads) and as soon as one finishes, start running the next. I explored the systask command, but couldn't achieve to do this.
For that specific code you would be better off renaming the data set test1000 to m1000. It would be faster and if these sets are of any size, a whole lot faster, could be done in one call to proc data sets. Example:
data junk1;
x=3;
run;
data junk2;
x=4;
run;
proc datasets library=work nolist nodetails;
change Junk1 = New1
Junk2 = New2
;
run;
quit;
As an aside, the above approach won't let you accidentally overwrite an existing "new" data set if exists, which might be a good thing if this is getting turned loose on unsuspecting data.
