topic Re: How to include a program multiple times in egp in SAS Enterprise Guide

How to include a program multiple times in egp

Laura1890 — Thu, 06 Apr 2023 08:35:08 GMT

Hello,

we have written a piece of code in a programm that we would like to include in serveral processflows in our egp. We couldn't figure out how to do that and still be able to refine the code so that it is up to date everywhere it is included in the project.

Thanks for ypur help!

Re: How to include a program multiple times in egp

yabwon — Thu, 06 Apr 2023 09:47:37 GMT

I guess EG works on Windows and connects to a server, in such case store file with the code on the machne, e.g. "/myCodes/code.sas" and in your EG project add code block with this line:

%include "/myCodes/code.sas";

Bart

Re: How to include a program multiple times in egp

fja — Fri, 07 Apr 2023 06:55:47 GMT

Hello!

... and Welcome to the community! 🙂 What about keeping it as a separate (external) piece of code and include it in the individual processes?

--FJa

Re: How to include a program multiple times in egp

AhmedAl_Attar — Sat, 08 Apr 2023 23:25:42 GMT

Hi @Laura1890

Depending on how/where your EG execute the code. While EG can be installed on your personal Windows machine, it can execute code in the following modes

Connecting to Local installation of SAS --> The code is executed from locally accessible location
Connecting to Remote Server installation of SAS --> The code has be stored on the Remote SAS server in order to be accessible and executed

In order to include the program multiple times in EG, Check the Tools --> Options --> SAS Programs
There are "Additional SAS code" options that might give what you are looking for

Hope this helps

Re: How to include a program multiple times in egp

Laura1890 — Thu, 13 Apr 2023 11:47:26 GMT

This is what we tried: we saved the code snipped as "programm.sas"-file but we can include it once in the process flow (so that the filepath is correct and the programm ist not "embedded" in the project). If we add it a second time the programm is only embedded and thus can not be changed properly.

Re: How to include a program multiple times in egp

AhmedAl_Attar — Thu, 13 Apr 2023 14:14:13 GMT

Hi @Laura1890

How about taking @yabwon approach?

In every Process Flow, Add an embedded Program entry named "Call_External" (as an example) and have the following statement inside every embedded program

%include "<SavedExternalProgramm.sas>";

Just a thought, hope this helps

Re: How to include a program multiple times in egp

fja — Fri, 14 Apr 2023 06:27:43 GMT

Laura,

could I ask another piece of information, please? The piece of code, what does it take as input and what does it produce as output? I had a little play with EG and was asking myself, what kind of program could sensibly used several times in a flow. Perhaps its input data is altered during the flow.

--fja

Re: How to include a program multiple times in egp

Laura1890 — Fri, 14 Apr 2023 06:32:30 GMT

It only takes tables from the database as input and creates tables on our database as output.

Re: How to include a program multiple times in egp

Laura1890 — Fri, 14 Apr 2023 06:37:20 GMT

I would like to share what we tried and worked so far:

You can include a new program to a process flow, save it and then change the filepath to the existing program (that is already included in another project flow in the same project). In order that the filepath still works with relative paths it is necessary to save the .egp-file using "save as"... and save as a new file. This sounds weird to me, but worked so far.

Re: How to include a program multiple times in egp

fja — Fri, 14 Apr 2023 11:06:09 GMT

So it is to be included in the same Project but in different flows ... but per flow only once?

--fja

Re: How to include a program multiple times in egp

Laura1890 — Fri, 14 Apr 2023 11:39:50 GMT

Yes, maybe this helps with the project setup:

The programs 2/3/4/5 in Flow 2 and Flow 5 refer all to the (respectively) same .sas-file

Re: How to include a program multiple times in egp

yabwon — Fri, 14 Apr 2023 11:58:37 GMT

Does this code you want to attach execute the same thing in each of your programs?

If so I would do the following:

1) create file "myScript.sas" and inside it do:

%macro wrapperForMyScript();

/* Put your code here so it will be wrapped inside a macro */

%mend wrapperForMyScript;

2) add an autoexec process calling %include (remember code is in macro now so it will compile)

3) add %wrapperForMyScript() inside your programs in places you want your code to be executed.

Bart

Re: How to include a program multiple times in egp

fja — Fri, 14 Apr 2023 12:24:33 GMT

@Laura1890 wrote:
You can include a new program to a process flow, save it and then change the filepath to the existing program (that is already included in another project flow in the same project).

I could not reproduce that on EG 8.2. It complained, that the file was already referenced by the project ...

So EG does obviously try to prevent you from including a program mutliple times in a project. One could possibly trick EG by using OS links but then I would rather go for the %include method already mentioned in the first post by @yabwon.

--fja