topic Re: How do you stop an input/output table from loading and return to the process flow? in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/250990#M17732 <P>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.</P><P>&nbsp;</P><P>Tom</P> Fri, 19 Feb 2016 00:22:47 GMT TomKari 2016-02-19T00:22:47Z How do you stop an input/output table from loading and return to the process flow? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/250923#M17726 <P><SPAN>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?</SPAN></P> Thu, 18 Feb 2016 19:08:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/250923#M17726 Hadrien 2016-02-18T19:08:03Z Re: How do you stop an input/output table from loading and return to the process flow? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/250928#M17727 <P>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.</P> Thu, 18 Feb 2016 19:24:52 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/250928#M17727 SASKiwi 2016-02-18T19:24:52Z Re: How do you stop an input/output table from loading and return to the process flow? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/250961#M17728 <P>Thanks for the tip. I actually have that setting set to 1,000 rows. Perhaps SAS struggles loading tables while executing a process simultaneously.&nbsp;</P> Thu, 18 Feb 2016 20:56:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/250961#M17728 Hadrien 2016-02-18T20:56:51Z Re: How do you stop an input/output table from loading and return to the process flow? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/250990#M17732 <P>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.</P><P>&nbsp;</P><P>Tom</P> Fri, 19 Feb 2016 00:22:47 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/250990#M17732 TomKari 2016-02-19T00:22:47Z Re: How do you stop an input/output table from loading and return to the process flow? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/251034#M17734 <P>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.</P> <P>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.</P> Fri, 19 Feb 2016 07:01:39 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/251034#M17734 Kurt_Bremser 2016-02-19T07:01:39Z Re: How do you stop an input/output table from loading and return to the process flow? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/740894#M38798 <P>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.&nbsp;</P><P>&nbsp;</P><P><A href="https://blogs.sas.com/content/sastraining/2015/06/17/sas-enterprise-guide-suppress-output-data-tab-when-programming/" target="_blank">https://blogs.sas.com/content/sastraining/2015/06/17/sas-enterprise-guide-suppress-output-data-tab-when-programming/</A></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 12 May 2021 18:37:36 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-you-stop-an-input-output-table-from-loading-and-return-to/m-p/740894#M38798 marathoner 2021-05-12T18:37:36Z