How to execute code parallelly?

[Sheeba]

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

[ballardw]

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.

[Sheeba]

Hi Ballardw,

Thanks for the reply.

I will try to see if i can incorporate something keeping this point in mind.

Regards,

Sheeba

[Reeza]

https://communities.sas.com/t5/ODS-and-Base-Reporting/Parallel-Execution-of-SAS-Macro-With-include/t...

[Sheeba]

Hi Reeza,

Thanks a lot for the thread. this is really helpful

Regards,

Sheeba