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
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
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
Bless you 🙂
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?? 🙂
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.
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
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.
Thanks so much for pointing me to your blog! These suggestions are great and will absolutely help!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.