BookmarkSubscribeRSS Feed
Grumbler
Obsidian | Level 7

We have some existing EG projects that needs to rename some of the tables in the middle of the process flow.  However, it doesn't seem to be possible to rename without having to re-build the entire process again.

Is is a correction assumption?  If not, how should we rename work space tables that are already used?  Thanks.

4 REPLIES 4
Patrick
Opal | Level 21

Does below code sample answer your question and give you sufficient guidance?

data work.test;

  set sashelp.class;

run;

proc datasets lib=work nolist nowarn;

  change test=new_test;

  run;

quit;

proc print data=work.new_test;

run;

Grumbler
Obsidian | Level 7

but that doesn't change the data set in the project workflow right?  it works in changing the name in work space but doesn't seem to do anything for the project itself.

if you right click a data set in project and see the file name there, there is a "change" button.  but it's inactive so we can't do anything.

Patrick
Opal | Level 21

The code I've posted changes the name of the actual physical table in SAS Work. This is the bit on the Server side of the story. It doesn't change the name of nodes in a SAS EG process flow. That's part of the client side and of SAS EG metadata.

You won't be able to change client side nodes during code execution on the server. May be you explain a bit more in detail what you're actually doing and trying to achieve.

gergely_batho
SAS Employee

1. You can change the names of the output datasets in nodes that produce them (Query Builder, Filter and Sort, Append ... Code Node).

Sometimes you need to click on Modify sometimes it is enough to select Properties - Results.

Then you must (re)run those nodes. This will create the new data sets.

You don't need to recreate the whole diagram, but yes, it is a manual process.

2. Then you can change the inputs of nodes (tasks), that consume the work tables:

Right Mouse Click - Select Input Data

or in some cases(Append, Query Builder😞

Modify - and change datasources in the Task

Instead of step 2. you can select Tools - Project Maintenance

You can rename tables here.

I found, that here you can choose only an existing table as a new the data source, but that new table should not exist in the project!


For some tasks (Filter and Sort) I was unable to change the data source

Message was edited by: Gergely Bathó

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
  • 4 replies
  • 5157 views
  • 2 likes
  • 3 in conversation