topic Renaming SAS datasets to use new libraries in SAS Programming

Renaming SAS datasets to use new libraries

Aasth — Tue, 29 Jan 2019 18:25:45 GMT

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?

Re: Renaming SAS datasets to use new libraries

Reeza — Tue, 29 Jan 2019 18:46:33 GMT

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.

Re: Renaming SAS datasets to use new libraries

Aasth — Tue, 29 Jan 2019 18:49:56 GMT

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

Re: Renaming SAS datasets to use new libraries

SASKiwi — Tue, 29 Jan 2019 20:07:08 GMT

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.

Re: Renaming SAS datasets to use new libraries

Aasth — Tue, 29 Jan 2019 20:11:43 GMT

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

Re: Renaming SAS datasets to use new libraries

34reqrwe — Tue, 29 Jan 2019 20:21:18 GMT

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

Re: Renaming SAS datasets to use new libraries

Aasth — Sun, 03 Feb 2019 04:47:45 GMT

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.