Contents
About
Product Notes
What’s New in SAS Scalable Performance Data (SPD) Server 5.2
What’s New in SPD Server 5.2?
Using SAS Scalable Performance Data (SPD) Server
Overview of SAS Scalable Performance Data (SPD) Server
Overview of SAS Scalable Performance Data (SPD) Server
The SPD Server Client/Server Model
Accessing SPD Server Using SAS
Securing SAS Data
SPD Server Extensions to Base SAS
Connecting to SAS Scalable Performance Data (SPD) Server
Introduction
Accessing SPD Server from a SAS Client
SPD Server Table Options
Accessing and Creating SAS Scalable Performance Data (SPD) Server Tables
SAS and SPD Server Tables
SPD Server Resource Security
Using a LIBNAME Statement to Access SPD Server
Managing Large SPD Server Files
Migrating Tables between SAS and SPD Server
Accessing and Manipulating Data with the SQL Pass-Through Facility
Creating a New Table
Indexing, Sorting, and Manipulating SAS Scalable Performance Data (SPD) Server Tables
Indexing Tables
Examples of Creating SPD Server Indexes
SAS Scalable Performance Data (SPD) Server Dynamic Cluster Tables
Overview of Dynamic Cluster Tables
Dynamic Cluster Table Structure
Benefits of Dynamic Cluster Tables
Dynamic Cluster Table Operations
Dynamic Cluster BY Clause Optimization
Member Table Requirements for Creating Dynamic Cluster Tables
Querying and Reading Member Tables in a Dynamic Cluster
Unsupported Features in Dynamic Cluster Tables
Dynamic Cluster Table Examples
SAS Scalable Performance Data (SPD) Server SQL Features
SAS Scalable Performance Data (SPD) Server SQL Features
Differences between SAS SQL and SPD Server SQL
Connecting to the SPD Server SQL Engine
SPD Server SQL Dictionary Tables
Specifying SPD Server SQL Planner Options
Important SPD Server SQL Planner Options
Parallel Join Facility
Parallel Group-By Facility
Parallel Group-By SQL Reset Options
SPD Server STARJOIN Facility
STARJOIN RESET Statement Options
SPD Server STARJOIN Examples
SPD Server Join Planner
SPD Server Index Scan
Optimizing Correlated Queries
Correlated Query Options
SPD Server SQL Views
SPD Server SQL Extensions
SPD Server SQL Cluster Operations
SAS Scalable Performance Data (SPD) Server Reference
Optimizing SAS Scalable Performance Data Server (SPD) Server
SPD Server Performance and Usage Tips
Symmetric Multiple Processor (SMP) Utilization
File System Performance Concepts
LIBNAME Domains
Loading Data into an SPD Server Host
Table Loading Techniques
Loading Indexes in Parallel
Truncating Tables
Optimizing WHERE Clauses
SPD Server Indexing
WHERE Clause Planner
How to Affect the WHERE Planner
Identical Parallel WHERE Clause Subsetting Results
WHERE Clause Examples
Server-Side Sorting
SAS Scalable Performance Data (SPD) Server Macro Variables
Introduction
Variable for Compatibility with the Base SAS Engine
Variables for Miscellaneous Functions
Variables for Sorts
Variables for WHERE Clause Evaluations
Variables That Affect Disk Space
Variables to Enhance Performance
Variable for a Client and a Server Running on the Same UNIX Machine
Variable for Logging of Implicit Pass-Through SQL Messages
SAS Scalable Performance Data (SPD) Server LIBNAME Options
Introduction
Options to Locate an SPD Server Host
Options to Identify the SPD Server Client
Options to Specify Implicit SQL Pass-Through
Options for Access Control Lists (ACLs)
Options for a Client and Server Running on the Same UNIX Machine
Options for Other Functions
SAS Scalable Performance Data (SPD) Server Table Options
Introduction
Option for Compatibility with Base SAS Software
Options That Affect Disk Space
Options to Enhance Performance
Option to Test Performance
Options for Hadoop Environments
Options for WHERE Clause Evaluations
Options for Other Functions
Options for Security
SAS Scalable Performance Data (SPD) Server Formats and Informats
Introduction
Formats
User-Defined Formats
Informats
SAS Scalable Performance Data (SPD) Server NLS Support
Overview of NLS
Character Encoding
Moving Data across Environments with Different Encodings
Base SAS Encoding Behavior
Setting the Encoding for Base SAS Sessions
Changing the Encoding for Base SAS Sessions
NLS Support in SPD Server
Using SAS Scalable Performance Data (SPD) Server with Other Clients
Overview of Using SPD Server with Other Clients
Using Open Database Connectivity (ODBC) to Access SPD Server Tables
Using Java Database Connectivity (JDBC) to Access SPD Server Tables
SAS Scalable Performance Data (SPD) Server SQL Access Library API Reference
Introduction
Overview of SPQL Usage
SPQL API Description
SPQL Library
SPQL API Functions
SPQL Function Return Codes
SPD Server Appendices
SPD Server Advanced User Topics
SPD Server Advanced User Topics
Accessing SPD Server through SAS
Organizing SAS Data
SPD Server Performance Enhancements
Using SPD Server with Data Warehousing
SPD Server Macro Variables
Using a LIBNAME to Statement to Access SPD Server
Managing Large SPD Server Files
Indexing SPD Server Tables
SPD Server Join Planner
SPD Server Join Planner Examples
SPD Server STARJOIN Optimization
SAS Scalable Performance Data (SPD) Server Frequently Asked Questions
SAS Scalable Performance Data (SPD) Server SQL Syntax Reference Guide
SPD Server SQL Syntax
Document Conventions
SQL Syntax Definitions
SQL Statements
SQL Building Blocks
SQL and WHERE-Processing Functions Supported by SPD Server
Product
Release
SAS Scalable Performance Data Server
5.2
Type
Usage and Reference
Copyright Date
April 2015
Last Updated
15Apr2015