topic Renaming Work Tables in SAS Enterprise Guide

Renaming Work Tables

Grumbler — Mon, 29 Jun 2015 07:59:22 GMT

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.

Re: Renaming Work Tables

Patrick — Mon, 29 Jun 2015 08:34:03 GMT

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;

Re: Renaming Work Tables

Grumbler — Mon, 29 Jun 2015 09:39:33 GMT

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.

Re: Renaming Work Tables

Patrick — Mon, 29 Jun 2015 10:09:12 GMT

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.

Re: Renaming Work Tables

gergely_batho — Mon, 29 Jun 2015 10:31:45 GMT

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ó