06-29-2015 03:59 AM
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.
06-29-2015 04:34 AM
Does below code sample answer your question and give you sufficient guidance?
proc datasets lib=work nolist nowarn;
proc print data=work.new_test;
06-29-2015 05:39 AM
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.
06-29-2015 06:09 AM
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.
06-29-2015 06:31 AM
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ó