SAS Script to edit sas programs in a library

[ren2010]

Hi,

I have a requirement to change the libnames in a library that houses more than 500 sas programs.Is there any way that I can write a SAS program that goes to each of these programs and changes the

library name?

Please let us know your thoughts or any sample code.

Thanks in advance.

Renjith

[ballardw]

How many different LIBNAMEs are involved? What are the rules for changing the LIBNAMEs? If these two questions can't be answered cleanly then you may have some problems.

If there are only a few LIBNAMES involved I might suggest moving the declarations to a common AUTOEXEC.SAS or included file than all users can share if that is practical in your environment.

[ren2010]

Here is how I plan to change the libnames:

In old server: I have all the programs in the following library:

    libname old \\oldserver\\productionjobs

I need to change the above libname to the following:

libname new \\newserver\\production\\jobs

I only have the above mentioned libnames

Thanks so much for your reply.

[Ksharp]

SAS program is only a txt file.You can read .sas file just as .txt file and use data step and tranwrd() function to change these libname statement.

Ksharp

[sbb]

To simplify the edit activity, use a SAS macro variable to resolve the <libref> portion of your LIBNAME statement.  You can use a %INCLUDE statement to include / execute a SAS code member that contains the %LET statements needed to resolve the current-value of the <libref> portion.  And with that the actual LIBNAME statement and other code remains static.

Scott Barry

SBBWorks, Inc.