BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Codexgo
Fluorite | Level 6

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!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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.

View solution in original post

4 REPLIES 4
Kurt_Bremser
Super User

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
Fluorite | Level 6

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
Super User

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
Super User

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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 678 views
  • 3 likes
  • 3 in conversation