https://communities.sas.com/t5/SAS-Enterprise-Guide/programmatically-control-query-builder/m-p/44649#M5143 Not sure if this will help...<BR /> <BR /> You could create a "shell" project with the query builder task in it that has the tables and joins and then copy that to start the new project.<BR /> <BR /> Doc Muhlbaier<BR /> Duke Tue, 05 Apr 2011 20:00:55 GMT Doc_Duke 2011-04-05T20:00:55Z https://communities.sas.com/t5/SAS-Enterprise-Guide/programmatically-control-query-builder/m-p/44648#M5142 The advantage of the query builder is that I can add and drop columns via the builder without having to memorize the dozens of tables and hundreds of variables available. I run a standard query that joins 9 tables and takes a long time to set up in the query builder. A view will not help in this instance because I want to choose needed columns for each project. Is there a way to populate the query builder with a standard set of tables and join logic? Please advise. Tue, 05 Apr 2011 19:28:33 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/programmatically-control-query-builder/m-p/44648#M5142 goat 2011-04-05T19:28:33Z https://communities.sas.com/t5/SAS-Enterprise-Guide/programmatically-control-query-builder/m-p/44649#M5143 Not sure if this will help...<BR /> <BR /> You could create a "shell" project with the query builder task in it that has the tables and joins and then copy that to start the new project.<BR /> <BR /> Doc Muhlbaier<BR /> Duke Tue, 05 Apr 2011 20:00:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/programmatically-control-query-builder/m-p/44649#M5143 Doc_Duke 2011-04-05T20:00:55Z https://communities.sas.com/t5/SAS-Enterprise-Guide/programmatically-control-query-builder/m-p/44650#M5144 Duke - Thanks for the quick response. That's exactly what I do now. I wish you could copy/paste an entire process flow from one project to another.<BR /> <BR /> Thanks again for your help!<BR /> goat Tue, 05 Apr 2011 20:07:01 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/programmatically-control-query-builder/m-p/44650#M5144 goat 2011-04-05T20:07:01Z https://communities.sas.com/t5/SAS-Enterprise-Guide/programmatically-control-query-builder/m-p/44651#M5145 Have you tried highlighting each node in the process and copying? I'm pretty sure that used to work Thu, 07 Apr 2011 21:31:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/programmatically-control-query-builder/m-p/44651#M5145 CameronLawson 2011-04-07T21:31:34Z