Desktop productivity for business analysts and programmers

Renaming Work Tables

Reply
Contributor
Posts: 42

Renaming Work Tables

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.

Respected Advisor
Posts: 3,825

Re: Renaming Work Tables

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;

Contributor
Posts: 42

Re: Renaming Work Tables

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.

Respected Advisor
Posts: 3,825

Re: Renaming Work Tables

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.

SAS Employee
Posts: 340

Re: Renaming Work Tables

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ó

Ask a Question
Discussion stats
  • 4 replies
  • 606 views
  • 2 likes
  • 3 in conversation