Joining at once in QueryBuilder at once with Filtering

[SASNE]

Hi Gurus,

i have three tables with one common key, once i pull those tables from the left pane,

i) is it better to join it through Query Builder and set filter (condition) at once (so that the DB server handle all queue ?)

or

ii) pull each table and filter fields (data -> filter, select necessary fields) first, then creates sas temp file and join them one by one

Which one is more effective ?

Thanks 

[SASNE]

Hi Gurus,


i have three tables with one common key, once i pull those tables from the left pane,


i) is it better to join it through Query Builder and set filter (condition) at once (so that the DB server handle all queue ?)


or


ii) pull each table and filter fields (data -> filter, select necessary fields) first, then creates sas temp file and join them one by one


Which one is more effective ?


Thanks  

Joining at once in QueryBuilder at once with Filtering

[Shmuel]

As much as I know qury builder will generate SQL program.

In this case, it will anyway join first 2 tables and then join the 3rd to the intermediate one.

So my advise is to do whatever is easier for you.

[SASNE]

Hi Shmuel,

Thank you for your help.

So that if i pull the 2 tables from SQLserver on left pane, then use Query builder join them , does it run the queue on the DB Server side ?

i know that if i let say filter the table first, then the new dataset will be save as Sas7dat format in Work folder, then any action later on will be on SAS server side.

Am i right ?

Thank you for your advice

[Shmuel]

You are probably working on SAS EG. My experience with query builder is limited,

but if you can post the log I would be able to answer your question.

[Kurt_Bremser]

I merged your identical questions into one thread. Please refrain from double-posting, it only makes following the answers difficult.

[LinusH · Accepted solution]

For most cases option 1 is preferred, at least from a performance point of view. But since every environment is unique I sugest yubtry both and compare.