PROC Python? Don't knw that? Is that different from FCMP? Have you got a pointer for me by chance? ... as I could not spot it in the documentation. Cheers fja   edit: Have it. Here for all other blinds: https://documentation.sas.com/doc/en/pgmsascdc/v_038/proc/p1iycdzbxw2787n178ysea5ghk6l.htm 🙂 ... View more

Link to the paper did not work for me. But can be found here: https://support.sas.com/resources/papers/proceedings20/4457-2020.pdf ... View more

Hi Kurt! Congrats to your ritrement! 😃 ... I have read about that on LinkedIn. You are all correct that typing SQL directly is way faster and provides way more control. It is just, that I am currently working for "business users" ... hence the question.   Cheers fja ... View more

Hello Ahmed! Thank you very much for your contribution. I do know the first link. It is a fine Introduction to the usage af task templates ... but does not answer the question posed, unfortuately. The scond link is new to me, I will have a look during lunch ... and will report 😉 Cheers fja   edit: The Webinar quoted is full of nice tips but does not answer my question (posed in the intial posting). ... View more

Hello Kurt! Thank you for your reply. In EG you can store an sql query (generated by EG) as a task template. These can be used to build up subqueries in an point and click fashion. I am not sure if they are in line with the term template in the PROC TEMPLATE context. Cheers   edit: .. and i did not manage to find them using list with PROC TEMPLATE ... but they get listed in the template section of tasks in the EG UI ... so my answer to your question would be a careful 'no'. But I am on shaky ground here. ... View more

@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 ... View more

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

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 ... View more

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 ... View more

Lovely! That makes sense ... seems that I was barking up the wrong tree entirely when trying to approach this from the EG side ... Thanks for giving me a start! --FJa ... View more

Thank you for your kind response, Kurt! So this is a different thing than the Files Folder in Sas Studio I take it.  Is there any piece of Documentation you could point to that sheds some light on the EG behaviour? I did not manage to find any appropriate entry in the SAS Online Help. Cheers FJa ... View more

Hello ... that should work.  Just to check: You are seeing this and click "folder" there?   Cheers ... View more

 Hello @ShelleySessoms ! This is very kind of you. Thank you very much! --FJa ... View more