topic Re: EG Usage Question: How to have NO table objects added to Process Flow Grid? in SAS Enterprise Guide

EG Usage Question: How to have NO table objects added to Process Flow Grid?

Patrick — Wed, 15 Dec 2021 07:47:29 GMT

Hi all,

This is an EG usage/configuration question and something where a solution would make my developer life really better.

EG version is:

Question

When executing a program node how to have EG NOT add table objects to the Process Flow grid.

Below an example: I would like to execute Program without EG adding the created tables as nodes to the grid. Is there any option to do this?

Real life relevance

I'm using EG for ETL development and I've got a process flow with many nodes linked together. Some of the nodes create a lot of tables.

How I would like things to look like even after executing the flow:

How things do look like after execution - which makes it really hard to maintain these flows and add or modify the flows.

I have too often to delete manually and painfully the table nodes ....and it's only a question of time until I delete a code node by mistake when "cleaning-up".

If there is no option to instruct EG to NOT add the table nodes: Is there at least a simple way to remove all the table nodes from the grid?

Thanks,

Patrick

Re: EG Usage Question: How to have NO table objects added to Process Flow Grid?

andreas_lds — Wed, 15 Dec 2021 08:18:29 GMT

Unfortunately there seems to be no option to hide datasets / views.

Re: EG Usage Question: How to have NO table objects added to Process Flow Grid?

Patrick — Wed, 15 Dec 2021 21:53:20 GMT

@andreas_lds

Found it! 😊

Re: EG Usage Question: How to have NO table objects added to Process Flow Grid?

Quentin — Wed, 15 Dec 2021 21:56:55 GMT

There is an EG option where you can limit the number of tables that are added, and you can set it to 0.

If you go to options->Results->Results General the option is "Maximum number of output data sets to add to the project."

The default is 50. Try setting it to 0, I think it should do the trick.