• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 562
  • Last Modified:

Parallel Processing using SAS Connect

Hi all,

I have two steps in sequence as below


SQL code

then

1

drop table

then

2

data step

when I trigger the code the first step is taking so much time because of the instability in our database and the datastep after that is not executing till 1 is complete.

Is there any feature in sas where after the code is executed and comes to 1. It should execute independent of step 2  and step 2 should start executing without waiting for step 1.

I did some research online and found we can try sas connect with pipe function..


Can any one please help me on this.

Thanks
0
aruku
Asked:
aruku
1 Solution
 
d507201Commented:
You're right... SAS's MP/CONNECT could be a solution.  There are a few papers written on it.  Here are a couple that I did at SAS Conferences.  You might want to look at them in the order shown, from SUGI 25 to 27.

http://www2.sas.com/proceedings/sugi25/25/sy/25p283.pdf  -- Introduction to Parallel Processing
http://www2.sas.com/proceedings/sugi26/p269-26.pdf -- Introduction to MP/Connect, with some code
http://www2.sas.com/proceedings/sugi27/p107-27.pdf -- Advanced MP/Connect technique
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now