topic Re: How to execute code parallelly? in SAS Programming

How to execute code parallelly?

Sheeba — Thu, 25 May 2017 21:39:14 GMT

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

Re: How to execute code parallelly?

ballardw — Thu, 25 May 2017 22:40:38 GMT

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.

Re: How to execute code parallelly?

Reeza — Thu, 25 May 2017 23:09:00 GMT

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

Re: How to execute code parallelly?

Sheeba — Fri, 26 May 2017 16:15:31 GMT

Hi Ballardw,

Thanks for the reply.

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

Regards,

Sheeba

Re: How to execute code parallelly?

Sheeba — Fri, 26 May 2017 16:16:51 GMT

Hi Reeza,

Thanks a lot for the thread. this is really helpful

Regards,

Sheeba