Hi,
I have a program which creates a temporary dataset one which I am planning to subset into three temporary datasets – dataset A, dataset B, dataset C.
I have a macro calculate() which does a join and some calculations.
I need to pass each of the three datasets as input parameter to the macro so that the calculations are done for each of the three datasets : dataset A, dataset B, dataset C.
Is there any way I can do the macro call parallel so as to save the processing time. we have grid server
data A B C;
set one;
if col1= X then output A;
else if col1= Y then output B;
else if col1= Z then output C;
run;
Is there a way to execute the below macro calls in a parallel ? .
%calculate(A);
%calculate(B);
%calculate(C);
Thanks in advance,
Regards,
Sheeba
I would suggest looking to a process that does processing BY Col1;
And only at the end split results, if needed. Likely to save a lot of headaches in the long run.
Hi Ballardw,
Thanks for the reply.
I will try to see if i can incorporate something keeping this point in mind.
Regards,
Sheeba
Hi Reeza,
Thanks a lot for the thread. this is really helpful
Regards,
Sheeba
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.