Using the SAS® Scalable Performance Data Server®

Duration

2 days

Description

This course provides an overview of SAS Scalable Performance Data Server architecture and data, and index storage in SAS Scalable Performance Data Server. This course also covers installing SAS Scalable Performance Data Server, using SAS Scalable Performance Data Server SQL Pass-Through, and optimising SAS Scalable Performance Data Server resources. It includes hands-on practice with these tasks.

Prerequisite Skills

You should have attended SAS Essentials: An Introduction to SAS Programming or have an equivalent level of knowledge.

SAS Modules Used

SAS Scalable Performance Data Server.

Course Topics

Introduction to the SAS Scalable Performance Data Server

• the SAS Scalable Performance Data Server
• SAS data sets used.

SAS Scalable Performance Data Server Architecture

• connecting to the SAS Scalable Performance

Data Server with a SAS client

• investigating a client other than a SAS client
• parallel processing.

Installing the SAS Scalable Performance Data Server (self-study)

• installing on UNIX
• installing on Windows
• testing and troubleshooting.

Configuring the SAS Scalable Performance Data Server

• the parameter file
• physical disk setup
• the LIBNAME parameter file
• troubleshooting
• auditing.

Administration and Maintenance of the SAS Scalable Performance Data Server

• overview
• administering users
• controlling access: the SAS Scalable Performance Data Server Security Model
• administering and configuring using the SAS Management Console (self-study).

Storing and Loading Data in the SAS Scalable Performance Data Server

• data storage
• partitioning data
• using the LIBNAME statement
• loading data
• compression
• cluster tables.

Creating and Storing Indexes in the SAS Scalable Performance Data Server

• introduction
• index creation.

Using the SQL Procedure

• SQL Pass-Through Facility
• asynchronous execution
• parallel GROUP-BY
• SQL Pass-Through Facility and the LIBNAME statement.

Optimising Performance of the SAS Scalable Performance Data Server (Best Practices)

• introduction
• sorting the tables
• subsetting the tables using WHERE clauses
• scalability testing
• reviewing other optimisation techniques.