Renaming SAS datasets to use new libraries

[Aasth]

Hi Everyone,

I am working on SAS server and I have new libraries created that use new libnames. I want to change all the SAS data sets on my previous SAS programs to replace the old libraries with the new ones(that pint to a new database too). Is there a way I can do it ata time instead of clicking on each dataset and changing its name to point to new libraries?

[Reeza]

You can do a find an replace but it's dangerous. I wonder for historical programs if its worth just assigning two libraries to the same location and change it as you go forward or modify programs.

[Aasth]

I don't want to assign two libraries at the same location, just wanted to remove the old libraries with new ones

[SASKiwi]

If you just want to change all old dataset or library names to new ones through all of your programs, the Find and Replace tool in the SAS editors is a good way of doing this.

[Aasth]

Do we have find and replace for SAS EG projects too?

[34reqrwe · Accepted solution]

You can use "Project Maintenance" from the "Tools" menu to do this

[Aasth]

I have 1000's of old SAS EG program that have to point to new lib names(new databases). Is there any script to automate it, so that I don't have to do it manually in EG.