How do you stop an input/output table from loading and return to the process flow?

[Hadrien]

SAS can take a very long time to load an output table after you click on it from the process flow, is there a way to cancel it and return to the process flow window?

[SASKiwi]

Not that I'm aware of. You can set a limit on the number of rows displayed which would speed things up. By default it is 1M rows. You could try reducing that to see if it helps. It is in the Tools - Options - Data - Performance settings.

[Hadrien]

Thanks for the tip. I actually have that setting set to 1,000 rows. Perhaps SAS struggles loading tables while executing a process simultaneously. 

[TomKari]

What kind of a table is it? If it's a SAS dataset, I've never seen this kind of problem. But if it's a database table, you're being held hostage to the DBMS. Particularly if the unerlying DBMS object is a view, the entire view might have to be created to show you any data at all.

Tom

[Kurt_Bremser]

The communication between EG and the workspace server seems to involve a lot of back-and-forth with small data chunks; if network I/O and server load becomes congested, the individual latencies of the requests add up to noticeable delays.

At least my experience around here with a rather old server (IBM P5 based). WIll have comparative values once we move to a new (P8) server.

[marathoner]

You can suppress the output data. Go to Tools:Options:Results:Results General. In box "Maximum number of output data set to add to the project" set 0. 

https://blogs.sas.com/content/sastraining/2015/06/17/sas-enterprise-guide-suppress-output-data-tab-w...