• Contents
  • About
  • Title Page
  • Product Notes
    • SAS Scalable Performance Data (SPD) Server Product Notes
      • Overview
      • What’s New in SPD Server 4.53?
      • What's New in SPD Server 4.52?
      • What's New in SPD Server 4.5?
  • SPD Server Usage
    • SAS Scalable Performance Data (SPD) Server Overview
      • Introduction to SAS Scalable Performance Data (SPD) Server
      • The SPD Server Client/Server Model
      • Accessing SPD Server Using SAS
      • Securing SAS Data
      • Organizing SAS Data
      • SPD Server Performance Enhancements
      • SPD Server Extensions to Base SAS
      • Using SPD Server with Data Warehousing
    • Connecting to SAS Scalable Performance Data (SPD) Server
      • Introduction
      • SAS and SPD Server Tables
      • SPD Server Resource Security
      • Accessing SPD Server from a SAS Client
      • SPD Server Table Options
      • SPD Server Macro Variables
    • Accessing and Creating SAS Scalable Performance Data (SPD) Server Tables
      • Introduction
      • Using a LIBNAME Statement to Access SPD Server
      • Managing Large SPD Server Files
      • Migrating Tables between SAS and SPD Server
      • The SQL Pass-Through Facility
      • Creating a New Table
    • Indexing, Sorting, and Manipulating SAS Scalable Performance Data (SPD) Server Tables
      • Introduction
      • Indexing a Table
      • Creating SPD Server Indexes Examples
    • Using SAS Scalable Performance Data (SPD) Server with Other Clients
      • Overview
      • Using ODBC to Access SPD Server Tables
      • Using JDBC to Access SPD Server Tables
      • Using htmSQL to Access SPD Server Tables
      • Using SQL C API to Access SPD Server Tables
    • SAS Scalable Performance Data (SPD) Server Dynamic Cluster Tables
      • Introduction to Dynamic Cluster Tables
      • Dynamic Cluster Table Structure
      • Benefits of Dynamic Cluster Tables
      • Creating and Controlling Dynamic Cluster Tables
      • 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
  • SPD Server SQL Features
    • SPD Server SQL Features
      • SPD Server SQL Planner
      • Connecting to the SPD Server SQL Engine
      • Specifying SPD Server SQL Planner Options
      • Important SPD Server SQL Planner Options
      • Parallel Join Facility
      • Parallel Group-By Facility
      • Parallel Group-By SQL Options
      • SPD Server STARJOIN Facility
      • STARJOIN Options
      • STARJOIN Facility Reference
      • SPD Server Index Scan
      • Optimizing Correlated Queries
      • Correlated Query Options
      • SPD Server Views
      • View Access Inheritance
      • Materialized Views
      • SPD Server SQL Extensions
      • Differences between SAS SQL and SPD Server SQL
  • SPD Server SQL Reference
    • SPD Server SQL Syntax Reference Guide
      • Overview
      • Document Conventions
      • SQL Syntax Definitions
      • SQL Statements
      • NEW SQL Statements
      • SQL Building Blocks
    • SAS Scalable Performance Data (SPD) Server SQL Access Library API Reference
      • Introduction
      • Overview of SPQL Usage
      • SPQL API Description
      • SPQL API Functions
      • SPQL Function Return Codes
  • SPD Server Reference
    • Optimizing SPD Server Performance
      • 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
    • 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
    • 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 to Specify File Paths for Table Storage
      • Options for Access Control Lists (ACLs)
      • Options for a Client and Server Running on the Same UNIX Machine
      • Options for Other Functions
    • 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 WHERE Clause Evaluations
      • Options for Other Functions
      • Options for Security
    • SPD Server Formats and Informats
      • Introduction
      • Formats
      • User-Defined Formats Example
      • Informats
    • 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
  • Appendix
    • SPD Server Frequently Asked Questions
      • SPD Server Frequently Asked Questions


ProductRelease
SAS Scalable Performance Data Server4.53
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
09Jul2011