How many of us have wondered how to make server connection more of one-button click process in SAS Enterprise Guide? Generally, there are multiple servers available and depending on your need, you may want to switch them. However, once you decide to stick of particular development server, it is important to be aware that there exists an option of AUTOEXEC which denotes creating and saving simple one or multi-line automatic executable program node.
This program node must be named AUTOEXEC (case-insensitive) and saved in process flow Autoexec.
This program node contains libname statements to connect to specific libraries on desired server. As long as you check mark the setting "Automatically run "Autoexec" process flow when project opens" under Tools, Options, General.