BookmarkSubscribeRSS Feed
skeenan
Calcite | Level 5
How would I make a process flow repeatable? Similar input datasets which need the same queries that I've already written for another dataset. We in the EG3 world can't just move the arrows around. How can we change the input dataset without changing the coding in each query?

How can this be done in EG3??

Another procedure?
1 REPLY 1
ChrisHemedinger
Community Manager
You correctly imply that this is somewhat easier in EG 4.1, but here are some instructions for EG 3.

To change the input table for a query in EG 3, follow these steps:

1. Add the new table you want to use into your project.

2. Right-click on the query, select Copy. Then right- click in the project view and select Paste. This should make a copy of your query definition.

3. Open your new copy of the query definition. In the query builder window, click on the Tables tab.

4. In the Tables view, right-click on the table that you want to change. Select "Change Table Location" from the context menu, and then select Project Data. A window with a list of project data sources appears.

5. Select the desired table from the list. Note that the table should have the same columns as your old table, at least as used by your query, to ensure that the query is still valid.

6. Click OK, and then run the query.

Note: you can change the table properties like this without first adding the table to your project, but when you do that the table reference is updated in the project, which I don't think you want. Your question sounds like you want to reuse your query definition for another table.

Chris
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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
  • 1 reply
  • 595 views
  • 0 likes
  • 2 in conversation