BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mczeg
Calcite | Level 5

Currently I have several programs and queries in my project that have to run in a specific order.  If I just click "run project" EG will run in an order that doesn't allow the project to complete properly, as a result I need to go back and rerun certain parts.  Is there a way to specify what order programs and queries run?  I've tried the "link to" functionality but that didnt seem to work.  Any help would be appreciated.

 

For what its worth, my project is a combination of SQL pass through code and SAS EG query builders.  I am also pulling data into my project that resides on different servers and is being joined via query builders.

 

Matt

1 ACCEPTED SOLUTION

Accepted Solutions
3 REPLIES 3
mczeg
Calcite | Level 5
Thanks...I wasn't aware of this function. Worked great.
ChrisHemedinger
Community Manager

You can link your task and program nodes together to enforce a sequence.  Right-click on any node, select Link... and then select the next node to link it to.  By adding a link, say from "Program A" to "Query B", you are guaranteed that EG will wait for "Program A" to complete before starting "Query B".

 

userlink.png

 

In the above example, "create_ratings_data" and "Ratings Format" will run before "Calc Days and Ratings" -- good thing, because in that query node I reference the format that was defined in "Ratings Format".

 

You can add as many user-defined links as you need within a process flow.

 

If you need to run tasks from different flows in a defined sequence, then use the Ordered List as @Reeza suggested. 

 

SAS Hackathon registration is open! Build your skills. Make connections. Enjoy creative freedom. Maybe change the world.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 12767 views
  • 1 like
  • 3 in conversation