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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.