topic Re: Prevent Auto-load of table in EG in SAS Enterprise Guide

Prevent Auto-load of table in EG

RPYee — Fri, 15 Sep 2017 20:21:37 GMT

When I select multiple tables and drag them to the project area, the icons for the tables show and I'm able to start working on the join statements, et al. When I drag only one table to the project area, the table is automatically opened. The data is often monstrous, so this is very time consuming as I have to wait for the sample rows to finally show. Is there a way to turn this feature off? I guess I could drag two tables over then delete one, but that's inefficient, too...

Your thoughts?
Thanks!

Rita Yee

Project Engineer, FedEx Express

Re: Prevent Auto-load of table in EG

jimbarbour — Fri, 15 Sep 2017 20:25:23 GMT

Rita,

Have you tried Tools, Options, Data, Data General? There's a check box there that says "Automatically open data when added to project." Try unchecking that box.

Jim

Re: Prevent Auto-load of table in EG

RPYee — Fri, 15 Sep 2017 20:26:02 GMT

Bless you 🙂

Re: Prevent Auto-load of table in EG

ChrisHemedinger — Fri, 15 Sep 2017 20:26:16 GMT

Check (actually uncheck) this option in Tools->Options, Data, Data General:

You might take a little time to explore some other options settings too. You can eliminate several behaviors that you might find annoying -- not all of the out-of-the-box settings are best for everyone. Here are my recommendations.

Re: Prevent Auto-load of table in EG

RPYee — Fri, 15 Sep 2017 20:33:34 GMT

Well, I haven't tried it yet because my table is still trying to load. Any suggestions on how I stop it without CTRL-ALT-DEL?? 🙂

Re: Prevent Auto-load of table in EG

RPYee — Fri, 15 Sep 2017 20:34:36 GMT

Thanks so much for pointing me to your blog! These suggestions are great and will absolutely help!

Re: Prevent Auto-load of table in EG

ChrisHemedinger — Fri, 15 Sep 2017 20:37:13 GMT

I'm afraid you can't interrupt the table loading... But, a slow-loading table is an indication of another problem. Data -- even large data -- should not take that long to load into the data view, which reads only small batches of records at a time. Unless the tables are extremely wide or are coming from a database/network location with high latency, you should not expect such a delay.

Making that better is usually a conversation with your SAS admin and maybe a database admin to see what can be done. Might be a tweak on the library definition, or a different approach for how you access that data.

Re: Prevent Auto-load of table in EG

TomKari — Fri, 15 Sep 2017 22:43:16 GMT

Another place that I've experienced slow initial loading of the view of the table is if the underlying data is a view in a database; although EG (via SAS) is only requesting a small number of records, in the background the database engine has to instantiate the entire view to return those records.

Turning off the preview, as Chris suggested, gets rid of this problem as well.

Tom