topic Re: How do I turn off the automatic join of the tables? in SAS Enterprise Guide

How do I turn off the automatic join of the tables?

JSJ — Mon, 11 Apr 2016 13:45:00 GMT

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!

Re: How do I turn off the automatic join of the tables?

TomKari — Mon, 11 Apr 2016 14:13:20 GMT

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

Re: How do I turn off the automatic join of the tables?

JSJ — Mon, 11 Apr 2016 14:23:09 GMT

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!

Re: How do I turn off the automatic join of the tables?

Reeza — Mon, 11 Apr 2016 14:29:56 GMT

What version of EG are you on?

Re: How do I turn off the automatic join of the tables?

JSJ — Mon, 11 Apr 2016 14:38:40 GMT

SAS EG 7.1
Thanks!

Re: How do I turn off the automatic join of the tables?

Loko — Mon, 11 Apr 2016 14:58:34 GMT

Tools-Options-Query - Automatically attempt to join tables in query

Re: How do I turn off the automatic join of the tables?

JSJ — Mon, 11 Apr 2016 14:50:56 GMT

Perfect!

For anyone else reading this, it is tools>options>query

There is a picture of the screen in the attachment--

Thanks soooo much!