topic Re: Joining at once in QueryBuilder at once with Filtering in SAS Enterprise Guide

Joining at once in QueryBuilder at once with Filtering

SASNE — Sun, 19 Feb 2017 13:46:45 GMT

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 ?)

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

SASNE — Sun, 19 Feb 2017 13:47:51 GMT

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

Re: Joining at once in QueryBuilder at once with Filtering

Shmuel — Sun, 19 Feb 2017 14:30:24 GMT

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.

Re: Joining at once in QueryBuilder at once with Filtering

SASNE — Sun, 19 Feb 2017 14:50:52 GMT

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

Re: Joining at once in QueryBuilder at once with Filtering

Shmuel — Sun, 19 Feb 2017 15:10:34 GMT

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.

Re: Joining at once in QueryBuilder at once with Filtering

Kurt_Bremser — Sun, 19 Feb 2017 18:25:30 GMT

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

Re: Joining at once in QueryBuilder at once with Filtering

LinusH — Mon, 20 Feb 2017 05:18:38 GMT

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.