<div>
<div class="content wysiwyg-content">
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 &nbsp;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 

</div>
</div>

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


Parallel Processing using SAS Connect

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.