DOCUMENTATION
  • Software
    • Software
    • SAS Viya
    • Industries
    • Solutions
    • Products
  • Learn
    • Learn
    • Training
    • Certification
    • Academics
    • Books
    • Video Tutorials
  • Support
    • Support
    • Communities
    • Documentation
    • Developers
    • Support & Services
    • User Groups
  • About Us
    • About Us
    • Why SAS?
    • Company
    • Careers
    • Newsroom
    • Events
    • Contact Us
  • Explore
    • Explore
    • Try & Buy
    • Why SAS?
    • Customer Stories
    • Partners
    • Consulting
  • Software
  • SAS Viya
  • Industries
  • Solutions
  • Products
  • Learn
  • Training
  • Certification
  • Academics
  • Books
  • Video Tutorials
  • Support
  • Communities
  • Documentation
  • Developers
  • Support & Services
  • User Groups
  • About Us
  • Why SAS?
  • Company
  • Careers
  • Newsroom
  • Events
  • Contact Us
  • Explore
  • Try & Buy
  • Why SAS?
  • Customer Stories
  • Partners
  • Consulting
  • Contact Us
Sign In

Create Profile

My SAS

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SAS® Help Center
SAS® Viya® Platform Programming Documentation
2026.08
|PDF 
Feedback
 
  • Welcome to SAS Programming Documentation
  • What's New
  • Learning SAS Viya Platform Programming
  • Syntax Quick Links
  • Python Programming
  • Advanced Analytics
  • Data Access
  • Cloud Analytic Services
  • SAS Language Reference
  • Migrating to UTF-8
  • Example Data Sets
  • SAS Code Debugging
  • Output and Graphics
  • In-Database Processing
  • Security and Administration
  • SAS Servers
    • SAS Scalable Performance Data Server
      • User’s Guide
      • Administrator’s Guide
  • Using the batch Plug-In for the SAS Viya CLI
  • Accessibility on the SAS Viya Platform
  • SAS Data Quality
  • SAS Job Execution Web Application Doc Link
  • SAS Job Execution Web Application
  • SAS Data and AI Studio
  • SAS Visual Analytics
  • SAS Viya Platform: Administration
  • SAS Viya Platform Operations
  • Other Resources
User’s Guide
 

SAS® Scalable Performance Data Server: User’s Guide

Introduction
About This Book
Overview of SAS Scalable Performance Data Server
Getting Started with SPD Server
Connecting to the Server
Loading and Creating Data on the Server
Indexing and Sorting Tables
Creating and Using Dynamic Cluster Tables
Creating and Using Server Views
SPD Server SQL Processor
Understanding the SPD Server SQL Processor
Optimizing SPD Server Queries
SQL Planner Options
Join Planner
Parallel Join Facility
Parallel Group-BY Facility
STARJOIN Facility
Optimizing Index Scans and Correlated Queries
Server-Side Sorting
WHERE Clause Planner
SPD Server Reference
SPD Server LIBNAME Statement
Explicit Pass-Through SQL Statements
SPD Server SQL Statement Additions
SPD Server Functions, Formats, and Informats
SPD Server Macro Variables
SPD Server Table Options
National Language Support
Last updated: October 18, 2021
Privacy Statement Terms of Use 
Copyright © SAS Institute Inc. All Rights Reserved