Select a Default Server for the SAS Add-In for Microsoft Office

Using the Connections window, you can specify which server you want to access. You connect to a server to access data sources and to run SAS tasks. To select a server for the active profile, follow these steps:
  1. Open the Connections window as described in Create a Connection Profile.
  2. Click Servers, click the down arrow, and select a default SAS server.
  3. (Optional) Select Automatically add local SAS server (if installed) to the list.
Note: Performance improvements can be achieved when groups of users select a load-balancing cluster of SAS Workspace Servers. For information about load-balancing, see the SAS Intelligence Platform: Application Server Administration Guide.