BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hello,

sorry for my bad english, I'm writing to you from Germany. I'm currently switching over from MS Analysis Services to SAS and to evaluate Enterprise Guide.

I try to do some ETL steps in EG. I assigned librefs with the LIBNAME statement, opened and joined tables with Query Procs and uses LIBNAME to deallocate the librefs.

The Project works fine if I run it step by step:
1. LIBNAME ...
2. Open Table ...
3. Join ... and write back
4. LIBNAME ... CLEAR

But when I run the whole project I get multiple error messages. Reason is that step 1, 2 and 4 execute the same time, which doesn't work of course.

Is there any way to set a step order?

Thank you for your answer and sorry for my english,
Sandro Kürschner
6 REPLIES 6
ChrisHemedinger
Community Manager
Sandro,

EG 3.0 runs project items as arranged in the flow: left to right, top to bottom.

In EG 4.1 you can connect your tasks/programs together in the flow by "drawing" lines between them, like so:

LIBNAME code--->Open Table code--->Join/writeback--->LIBNAME Clear

This guarantees the execution order. Also, there is a tool called Ordered List that allows you to group a set of tasks/programs in whatever sequence you like and run them as a unit.

Chris
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
deleted_user
Not applicable
Thank you for this info, I'll try it instantly!
deleted_user
Not applicable
Along the same lines (somewhat), does EG 4.1 allow you to STOP the process flow should one of your code nodes fail. If an earlier step fails, can you prevent the rest of the process flow from running?
Message was edited by: rup45 at Apr 5, 2006 1:27 PM
ChrisHemedinger
Community Manager
Hi,

No, this is not in EG 4.1. However, it is being considered for a future release: a way to affect the process flow toward one action or another based on a set of conditions (such as an error).

Chris
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
deleted_user
Not applicable
I think it would be a great addition and will help when working through error handling especially. You are unable to use something like an ABORT statement when trying to terminate execution in EG - currently we're getting around this by coding conditional INCLUDES and/or macros.

Keep us all posted.
NeilConstable
SAS Employee
EG4 has improved things slightly with regard to errors. In eg3 if a step failed then the process flow continued and could easily use old versions of the data which should have been generated in the failed step. In 4 there is a delete data sets and formats task enabling you delete generated data sets before you start. Then at least the whole thing fails and does not give apparently updated results based on old data.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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
  • 6 replies
  • 885 views
  • 0 likes
  • 3 in conversation