How do I turn off the automatic join of the tables?
We like to do our own joins!
We turned this off in a previous version, so I know it can be done!
Thanks!
Jo
Definitely something you want to know. Especially since EG doesn't always pick the right columns to join!
Right click on the link between the columns, and click on "Delete Join".
Tom
Thanks for your response! We definitely delete the join and re- add. My question is how to turn off the auto join part, since it is mostly not what we want in the majority of cases!
What version of EG are you on?
Tools-Options-Query - Automatically attempt to join tables in query
Perfect!
For anyone else reading this, it is tools>options>query
There is a picture of the screen in the attachment--
Thanks soooo much!
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.