Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor
Posts: 15

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

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?

Respected Advisor
Posts: 3,063

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

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.

Occasional Contributor
Posts: 15

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

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

Trusted Advisor
Posts: 1,052

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

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

Esteemed Advisor
Posts: 6,646

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 4 replies
  • 461 views
  • 2 likes
  • 4 in conversation