SAS/CONNECT

What is SAS/CONNECT?

SAS/CONNECT is an application that provides client/server services between a local SAS session (desktop) and one or more remote SAS sessions (server). It offers two types of services, which both use SAS Windows as the front end:

Compute Services (CS)

Remote Library Services (RLS)

Gives user access to all of the computing resources on the remote host.

Gives user access to all the data regardless of where they are stored.

Data processing takes place on the remote server

Data processing takes place on the local desktop

Best to use if there is a large amount of data involved

Best to use if there is a small to medium amount of data involved

How SAS/CONNECT Works

  • SAS/CONNECT allows you to connect a SAS session running on your desktop to SAS on the Research Grid.
  • To make connection, SAS/CONNECT uses a communications access method (e.g. TCP/IP, DECnet, Telnet) specific to the environment.

Reasons to Use SAS/CONNECT

  • User who feels more comfortable in the Windows environment
  • Output and log displayed in SAS window
  • Take advantage of remote processing speed (CS)
  • Enable access to data that is too large or dynamic to be transferred or processed in the local system (CS)
  • Transparent access to remote data (RLS)
  • Allow user to combine remote and local data in one program (RLS)
  • Eliminate need to transfer or create additional copies of the data because user works on only one copy of the data (CS/RLS)

Making a Connection with SAS/CONNECT

Since HBS community uses primarily TCP/IP as the access method and RCS supports only Linux servers, the following sections will cover instructions and examples of how to make the connection based on this communication protocol and server. It should be noted that a separate script in the SAS path on your PC is no longer needed. 

Starting and Stopping SAS/CONNECT with an Automatic Logon Script

There are a few ways to start SAS/CONNECT, but it is easiest to make the connection by running the three lines of code as shown below. For users who would like to start and stop SAS/CONNECT using the menu bar or shortcuts, please refer to the Usage and Reference manual for SAS/CONNECT Software. 

The general steps to establish and terminate the link are as follows:

  • Start a SAS session on your local operating system (desktop or laptop)
  • In the PROGRAM EDITOR, type in the following:
%let rmt=sasconnect.hbs.edu 7550 ;
options comamid=tcp   remote=rmt ;
signon user=_prompt_ password=_prompt_ ;

When SAS reads the sign-on statement you will be asked for your username and password. Successful execution of the connection script will be indicated in the log window. You can use rsubmit to start your SAS code submission and endrsubmit  to end your SAS code submission.  You can now use SAS/CONNECT to remotely submit SAS programs for execution on Unix or use RLS to access a file from Unix and process it locally.

When you have finished using SAS/CONNECT, please terminate the connection by clicking "Run" then "Signoff..." when the editor window is active.

After the SIGNOFF command executes successfully, a message in the LOG window will indicate that the link has been terminated.

SAS Examples

The examples below make the connection via TCP/IP using an automatic logon script.  They will help you understand how each of these services in SAS/CONNECT works and show how you may structure a program to make a link:

If you would like assistance with SAS/CONNECT, please contact Christine Rivera (5-6046), Research Database Analyst, Research Computing Services.