SAS File location for data migration

[Codexgo]

Hi Folks,

If i want to migrate the SAS programs from one server to another, do i have to worry about the statements which represent the location of files like Set statements, From statement in Proc SQL, Infile statements or Libraries or any thing related to file locations. 

If i move programs from one server to another will it impact my program ?

What considerations should we keep in mind while moving programs from one server to another ?

Thanks in advance!

[Kurt_Bremser]

Welcome to the communities!

Anything involving libraries (SET, MERGE or DATA statements, DATA= options, FROM clause in SQL) should not be of concern if the libraries are correctly defined (autoexec or metadata).

LIBNAME, FILENAME, FILE or INFILE statements or the respective options in other statements must point to correct physical pathnames.

I have always made it a point to keep the physical directory structure when moving our SAS environment to a new server, with the exception of parts that had been proven sub-optimal in the old environment.

[Codexgo]

So, if the physical directory structure changes when moving SAS environment to a new server, then anything related to libraries like SET, MERGE or DATA statements, DATA= options, FROM clause in SQL, LIBNAME, FILENAME, FILE or INFILE statements might not work ?

[Kurt_Bremser · Accepted solution]

If you adapt your library definitions (wherever they are made) correctly, everything that accesses datasets, views or catalogs through these libraries will work.

All code elements that use physical filenames will have to be adapted; the more of them you have in programs instead of autoexec or include files, the more work you will have finding and changing them.

[ballardw]

And %include and possibly locations mentioned on Proc Printto if used.