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
arukuAsked:
Who is Participating?
 
d507201Database Marketing ConsultantCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.