Client Server Processing Using SAS/CONNECT®, SAS/SHARE® and SAS/ACCESS® Software

Duration: 2.0 days CEUs: 1.2

AUDIENCE
This course is for SAS System users who need to access and process remote data.

BENEFITS
This course is designed to teach users how to connect to multiple platforms supporting SAS, move data between them and process data on the most appropriate system. Concurrent use of data and access to data not stored in SAS is discussed.

Students will learn to:
• Set up a remote connection
• Process data on the most appropriate operating system
• Remotely submit programs
• Get local access to remote SAS and DBMS data

PREREQUISITES
Programming I: SAS Essentials course, basic knowledge of your operating system environments and ability to:

• Run SAS programs
• Use the Display Manager interface
• Perform simple data manipulation
• Understand the basic commands available on your operating systems

COURSE TOPICS

Overview of Client/Server Computing

Establishing a SAS/CONNECT Session

Remote Computing
• Remote submission
• Connecting to multiple remote systems

Transferring Data
• The UPLOAD procedure
• The DOWNLOAD procedure

Using SAS/ACCESS Software to Access External Data
• The SQL Pass Through Facility
• Access and view descriptors

Using SAS/SHARE Software
• Server libraries
• Concurrent access

Remote Library Services

Client/Server in an SCL Application

CEDA – Cross Environment Data Access

Asynchronous vs. Synchronous Processing

Software Used: Base SAS, SAS/CONNECT®, SAS/SHARE® and SAS/ACCESS®.