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?
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.
Thanks for the tip. I actually have that setting set to 1,000 rows. Perhaps SAS struggles loading tables while executing a process simultaneously.
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
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.