topic Re: Is it possible to loop the whole Process Flow? in SAS Programming

Is it possible to loop the whole Process Flow?

IgorR — Wed, 06 Dec 2023 15:06:51 GMT

Hi!

I have Process Flow with more then 10 programs, and each program is between 400 to 500 rows of code.

Today I need to give him date, run it and wait two hours to end. Repeat 5 or 6 times.

I want to give him list of dates and run it at night to get al the results next morning.

The question - Can I loop the whole Process Flow without much programming effort and not to make changes to the programs code?

Thank you in advance.

Re: Is it possible to loop the whole Process Flow?

sbxkoenk — Wed, 06 Dec 2023 15:51:47 GMT

Hello,

Is this an Enterprise Guide Process Flow??
If yes, I will move this topic to a more appropriate board:

Home > Programming > Enterprise Guide

If it's matter of pure programming in SAS Studio or Display Manager, I can easily help you out, ... but this is about looping through an EG-process flow multiple times I am afraid. Meanwhile I have forgotten how to do that.

BR, Koen

Re: Is it possible to loop the whole Process Flow?

IgorR — Thu, 07 Dec 2023 06:15:29 GMT

I'm using SAS Enterprise Guide 8.3 .

I have Process Flow that include many Programs that run one by one, after I defined global variables that all these programs use.

I just want to save a lot of manual work here.

Re: Is it possible to loop the whole Process Flow?

Patrick — Thu, 07 Dec 2023 10:58:16 GMT

If you store your programs to an external location (on disk) then you could just write a single program with %include statements - and then of course you can wrap a macro loop around these %include statements for your dates. ...or you just generate the code with the %include statements once per date.

To my knowledge EG itself doesn't provide such a loop mechanism and any approach I know of needs the code stored externally (showing as icon with the little arrow).

And as an outlook for you: Under SAS Viya using SAS Studio Flow also such more operational requirements are fully supported.

Re: Is it possible to loop the whole Process Flow?

yabwon — Thu, 07 Dec 2023 10:41:18 GMT

@IgorR

Code export can be done by:

But if I were you I would go one step further. I would split the one huge exported file into separate macros, and then wrapped it up in a SAS Package, to have it:

1) modular,

2) to have it in single file,

3) to be able call its content in any SAS interface (including DMS, Studio, or even "future to be" Workbench), not only EG.

Detailed tutorial on how to develop and use SAS Packages is here.

Bart