1. Go to EGuide Explorer and deassign and reassign the old library nickname to the new place where the data resides?
2. My last resort is to right click on the icon and choose "Open Last Submitted Code". Then, I can copy and paste that code and modify it to go to the proper new place. Or, I can use the code to remind me of the options that I want as I create a new point & click task.
Swapping the libnames does seem like a good start. How about the following:
Assign a different libname to point to your "real" database.
Create a new SAS library, which will wind up containing nothing but views. Have your existing libname point to this new library.
In PROC SQL, create a view for each table with a name change, something like CREATE VIEW oldname.OldTableName AS SELECT * FROM diffname.NewTableName.
I'd pick one query first and try just creating the view(s) for the table(s) it uses, to see whether the idea works. Hopefully the optimizer will be smart enough that this will cost you little if anything performance-wise.