• 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


ProductRelease
SAS Scalable Performance Data Server5.2
Type
Usage and Reference
Copyright Date
April 2015
Last Updated
15Apr2015