Desktop productivity for business analysts and programmers

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

Accepted Solution Solved
Reply
Contributor JSJ
Contributor
Posts: 43
Accepted Solution

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

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


Accepted Solutions
Solution
‎04-11-2016 10:47 AM
Super Contributor
Posts: 308

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

[ Edited ]

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

 

Capture (1).PNG

View solution in original post


All Replies
PROC Star
Posts: 1,146

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

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

Contributor JSJ
Contributor
Posts: 43

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

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!

 

Super User
Posts: 19,167

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

What version of EG are you on?

Contributor JSJ
Contributor
Posts: 43

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

SAS EG 7.1
Thanks!
Solution
‎04-11-2016 10:47 AM
Super Contributor
Posts: 308

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

[ Edited ]

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

 

Capture (1).PNG

Contributor JSJ
Contributor
Posts: 43

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

Perfect!

 

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

 

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

Thanks soooo much!

 

 

 

 

 


Capture.PNG
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 464 views
  • 1 like
  • 4 in conversation