BookmarkSubscribeRSS Feed
goat
Calcite | Level 5
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.
3 REPLIES 3
Doc_Duke
Rhodochrosite | Level 12
Not sure if this will help...

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.

Doc Muhlbaier
Duke
goat
Calcite | Level 5
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.

Thanks again for your help!
goat
CameronLawson
Obsidian | Level 7
Have you tried highlighting each node in the process and copying? I'm pretty sure that used to work

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 922 views
  • 0 likes
  • 3 in conversation