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
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
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.
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
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.
I merged your identical questions into one thread. Please refrain from double-posting, it only makes following the answers difficult.
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.