How do I replace a table name (globally) in a SAS Enterprise Guide Project?

[jcz]

Should be simple...  What am I missing?

The Library Name and Metadata folder location of a table has changed...   I need to change the references in a fair number of projects to the new table...    

What is the fastest way to do this?

The metadata for <Data A> table has been changed... The Library name and the SAS Folder Location are different... see the red x...

Now, how to replace the occurrences with the new entry???

If I change the properties, it doesn't save it.   If I modify the 'filter' to point to the new table..  it wont save it...

Help!

[Pepijn]

Yeah this is a strange one.

First if this is your source table and you are querying it multiple times and there are duplicate filters in those query builders you called 'filter' then you might want to add a step next time. I make sure all my source tables have at least 1 query builder (sometimes even just a copy, no filters) before using it multiple times. The benefits are.

1. When something like this happens you can just query your new source table and rename the output table to the excisting one. For instance. name the output name from query builder B to the output name of query builder A. And then delete query builder A and the old source.

2. When you want to change the time period you only have to do it in query builder A. Also any new filters for both QB 1 and 2 can be done in one place.

3. Your source table is only approached once. (Benefits depend on the way your source tables are structured of course.)

4. When a new input table has different column names and you don't want to change them in multiple query builders or throughout every step in your query, just change them to the old ones in the first step.

Last but not least. There is also a fix for you problem I think. But it's in a weird place and you have to do it separate in all of your 'filter' query builders now.

1. open the join screen in your query builder (doesn't matter if your have an actual join or not).

2. Right click the name (or outlines) of your source table and choose properties

3. Source: --> Change en choose your new source table.

This works most of the times but not always, I don't know why. At least make sure the data is available, and make a new query builder from your new source and connect to that one instead of to your source tabel directly! That way you can also make sure the column names are the same etc.

Good luck!