DATA Step, Macro, Functions and more

How to execute code parallelly?

Reply
Regular Contributor
Posts: 167

How to execute code parallelly?

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

Super User
Posts: 11,343

Re: How to execute code parallelly?

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.

Regular Contributor
Posts: 167

Re: How to execute code parallelly?

Hi Ballardw,

 

Thanks for the reply.

 

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

 

Regards,

Sheeba

Super User
Posts: 19,770
Regular Contributor
Posts: 167

Re: How to execute code parallelly?

Hi Reeza,

 

Thanks a lot for the thread. this is really helpful

 

Regards,

Sheeba

Ask a Question
Discussion stats
  • 4 replies
  • 162 views
  • 2 likes
  • 3 in conversation