About this course

Course code TPDISPDU
Duration 2 Days

This course introduces the SAS Scalable Performance Data Server and provides hands-on experience accessing and creating SPD Server data from SAS.

Prerequisites

Before attending this course, you should have experience with SAS programming and Structured Query Language. You may gain the necessary SAS knowledge by completing the SAS Programming 1: Essentials and SAS SQL 1: Essentials. An understanding of the SAS macro language and SAS Enterprise Guide is helpful but not required. This knowledge can be acquired by completing the SAS Macro Language 1: Essentials and SAS Enterprise Guide 1: Querying and Reporting, respectively.

Who should attend?
BI Content Developers, Data Integration Developers, and SAS Programmers.

Delegates will learn how to

  • use the SPD Server LIBNAME engine
  • use the SPD Server SQL pass through facility
  • write SAS code to optimise the utilisation of SPD Server resources
  • use SAS Enterprise Guide to access SPD Server data (Self-Study)

Outline

Introduction

  • exploring the platform for SAS Business Analytics
  • introduction to the workshop scenario
  • introduction to the SAS Scalable Performance Data Server
  • SAS Scalable Performance Data Server architecture
  • SAS Scalable Performance Data Server security

Using SAS(R) Scalable Performance Data Server Tables

  • overview of SPD Server tables and indexes
  • using the LIBNAME statement
  • using the SQL procedure Pass-Through facility
  • subsetting SPD server tables
  • using WHERE clauses
  • investigating EVAL strategies for where costing (Self Study)

Creating and Utilising Cluster Tables

  • creating cluster tables
  • using the MINMAXVARLIST= table option

Managing SAS Scalable Performance Data Server Tables and Indexes

  • introduction to managing SPD server tables
  • partitioning tables
  • compression
  • loading data into SPD server tables
  • updating SPD tables
  • sorting SPD tables
  • temporary SPD server tables (self-study)

Using the SQL Procedure

  • overview
  • creating views
  • parallel GROUP BY
  • parallel joins
  • the query rewrite facility
  • star join facility
  • additional SQL topics

Optimising SAS Scalable Performance Data Server Performance

  • reviewing data storage optimisation

Reviewing programming optimisation

Appendix A - Glossary of Technical Terms

Software Addressed
This course addresses the following software product(s): Platform for SAS Business Analytics and SAS Scalable Performance Data Server.

2 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

The world's leading organisations trust QA with their learning and development.

Find out why

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.