• Contents
  • About
  • What’s New in SAS Scalable Performance Data Server
  • Introduction
    • About This Book
      • Overview
      • Audience
      • Documentation Conventions
    • Overview of SAS Scalable Performance Data Server
      • Introduction to SAS Scalable Performance Data Server
      • Benefits of SPD Server
      • Host Services for Clients
      • Accessing SPD Server Using SAS
      • SPD Server Additions to Base SAS
      • Other Ways to Access SPD Server
      • Using SPD Server
      • Utilities for Maintaining SPD Server
  • Getting Starting with SPD Server
    • Connecting to the Server
      • Overview of Connecting to SPD Server
      • Understanding the Name Server
      • Connect to SPD Server with a LIBNAME Statement
      • Changing Server Passwords
      • Connect to SPD Server with Explicit SQL Pass-Through
      • Nesting SQL Pass-Through Access
    • Loading and Creating Data on the Server
      • SAS and SPD Server Tables
      • Planning Your Server Tables
      • Formatting Your Data
      • Table-Loading Techniques
      • Table Creation Techniques
      • Enabling User Access to SPD Server Tables
    • Indexing and Sorting Tables
      • Understanding SPD Server Indexing
      • Index Creation Techniques
      • Using PROC CONTENTS to See Index Information
      • Sorting Data
    • Creating and Using Dynamic Cluster Tables
      • Introduction to Dynamic Cluster Tables
      • Creating Dynamic Cluster Tables
      • Adding Members to a Dynamic Cluster Table
      • Modifying a Dynamic Cluster Table
      • Refreshing Dynamic Cluster Tables
      • Undo a Dynamic Cluster Table
      • Restoring Removed or Replaced Cluster Table Members
      • Destroying Dynamic Cluster Tables
      • Querying and Reading Member Tables in a Dynamic Cluster
      • Comprehensive Dynamic Cluster Table Examples
      • Member Table Requirements for Creating Dynamic Cluster Tables
      • Optimizing Dynamic Cluster Tables
      • Unsupported Features in Dynamic Cluster Tables
    • Creating and Using Server Views
      • Overview of Server SQL Views
      • View Access Inheritance
      • Materialized Views
  • SPD Server SQL Processor
    • Understanding the SPD Server SQL Processor
      • SPD Server Supported SQL
      • Understanding the Server’s SQL Pass-Through
      • Differences between SAS SQL and SPD Server SQL
      • SPD Server SQL Dictionary Tables
  • Optimizing SPD Server Queries
    • SQL Planner Options
      • Overview of SQL Planner Options
      • Specifying SQL Planner Options
      • General SQL Planner Options
    • Join Planner
      • Understanding the SPD Server Join Planner
      • Join Planner Reset Option Examples
    • Parallel Join Facility
      • Understanding the Parallel Join Facility
      • Parallel Join Reset Options
      • Parallel Join Examples
    • Parallel Group-BY Facility
      • Understanding the Parallel Group-By Facility
      • Parallel Group-By SQL Reset Options
    • STARJOIN Facility
      • Understanding the STARJOIN Facility
      • STARJOIN RESET Statement Options
      • Example: STARJOIN RESET Statements
      • STARJOIN Examples
    • Optimizing Index Scans and Correlated Queries
      • Optimizing Index Scans
      • Optimizing Correlated Queries
      • Correlated Query Options
    • Server-Side Sorting
      • Server-Side Sorting
    • WHERE Clause Planner
      • Optimizing WHERE Clauses
      • Server Indexing with WHERE Clause
      • Understanding the WHERE Clause Planner
      • How to Affect the WHERE Planner
      • Identical Parallel WHERE Clause Subsetting Results
      • WHERE Clause Examples
  • SPD Server Reference
    • SPD Server LIBNAME Statement
      • Overview of the SPD Server LIBNAME Statement
      • ACLGRP= LIBNAME Statement Option
      • ACLSPECIAL= LIBNAME Statement Option
      • AUTHDOMAIN= LIBNAME Statement Option
      • BYSORT= LIBNAME Statement Option
      • CHNGPASS= LIBNAME Statement Option
      • DISCONNECT= LIBNAME Statement Option
      • ENDOBS= LIBNAME Statement Option
      • HOST= LIBNAME Statement Option
      • IP=YES LIBNAME Statement Option
      • LIBGEN= LIBNAME Statement Option
      • LOCKING= LIBNAME Statement Option
      • NETCOMP= LIBNAME Statement Option
      • NEWPASSWORD= LIBNAME Statement Option
      • PASSTHRU= LIBNAME Statement Option
      • PASSWORD= LIBNAME Statement Option
      • PROMPT= LIBNAME Statement Option
      • SCHEMA= LIBNAME Statement Option
      • SERVER= LIBNAME Statement Option
      • SHARE= LIBNAME Statement Option
      • STARTOBS= LIBNAME Statement Option
      • TEMP= LIBNAME Statement Option
      • TRUNCWARN= LIBNAME Statement Option
      • UNIXDOMAIN= LIBNAME Statement Option
      • USER= LIBNAME Statement Option
    • Explicit Pass-Through SQL Statements
      • SPD Server SQL Explicit Pass-Through Statements
      • CONNECT Statement
      • CONNECTION TO Statement
      • DISCONNECT Statement
      • EXECUTE Statement
    • SPD Server SQL Statement Additions
      • SPD Server SQL Statement Additions
      • BEGIN ASYNC OPERATION Statement
      • COPY TABLE Statement
      • CREATE VIEW Statement
      • END ASYNC OPERATION Statement
      • LIBREF Statement
      • LOAD TABLE Statement
    • SPD Server Functions, Formats, and Informats
      • Functions
      • Introduction to Formats and Informats
      • Formats
      • User-Defined Formats
      • Informats
    • SPD Server Macro Variables
      • Overview of SPD Server Macro Variables
      • SPDSUSDS Reserved Macro Variable
      • Functional List of SPD Server Macro Variables
      • SPDSAUNQ Macro Variable
      • SPDSBNEQ Macro Variable
      • SPDSBSRT Macro Variable
      • SPDSCLJX Macro Variable
      • SPDSCMPF Macro Variable
      • SPDSCOMP Macro Variable
      • SPDSDCMP Macro Variable
      • SPDSEINT Macro Variable
      • SPDSEOBS Macro Variable
      • SPDSEV1T Macro Variable
      • SPDSEV2T Macro Variable
      • SPDSFSAV Macro Variable
      • SPDSHOST Macro Variable
      • SPDSIASY Macro Variable
      • SPDSIPDB Macro Variable
      • SPDSIRAT Macro Variable
      • SPDSNBIX Macro Variable
      • SPDSNETP Macro Variable
      • SPDSNIDX Macro Variable
      • SPDSRSSL Macro Variable
      • SPDSSADD Macro Variable
      • SPDSSIZE Macro Variable
      • SPDSSOBS Macro Variable
      • SPDSSQLR Macro Variable
      • SPDSSTAG Macro Variable
      • SPDSTCNT Macro Variable
      • SPDSUSAV Macro Variable
      • SPDSVERB Macro Variable
      • SPDSWCST Macro Variable
      • SPDSWDEB Macro Variable
      • SPDSWSEQ Macro Variable
    • SPD Server Table Options
      • Overview of SPD Server Table Options
      • Functional List of SPD Server Table Options
      • ASYNCINDEX= Table Option
      • BYNOEQUALS= Table Option
      • BYSORT= Table Option
      • COMPRESS= Table Option
      • ENCRYPT= Table Option
      • ENCRYPTKEY= Table Option
      • ENDOBS= Table Option
      • IOBLOCKSIZE= Table Option
      • MINMAXVARLIST= Table Option
      • NETPACKSIZE= Table Option
      • NOINDEX= Table Option
      • PARTSIZE= Table Option
      • SEGSIZE= Table Option
      • STARTOBS= Table Option
      • SYNCADD= Table Option
      • THREADNUM= Table Option
      • UNIQUESAVE= Table Option
      • VERBOSE= Table Option
      • WHERENOINDEX= Table Option
    • SPD Server Access Library API Reference
      • Introduction to Access Using Library API
      • Overview of SPQL Usage
      • SPQL API Description
      • SPQL Library
      • SPQL Function Return Codes
      • SPQL API Functions
      • SPQLCOLINFO() API Function
      • SPQLCONNECT() API Function
      • SPQLDISCONNECT() API Function
      • SPQLFETCH() API Function
      • SPQLFREESTOK() API Function
      • SPQLGMSG() API Function
      • SPQLINIT() API Function
      • SPQLPERFORM() API Function
      • SPQLTABINFO() API Function
      • SPQLTERM() API Function
    • National Language Support
      • National Language Support
  • ODBC and JDBC Clients
    • Using SPD Server with ODBC and JDBC Clients
      • Introduction to Access Using ODBC and JDBC
      • Using ODBC to Access SPD Server Tables
      • Using JDBC to Access SPD Server Tables
  • Recommended Reading
  • Glossary


ProductRelease
SAS Scalable Performance Data Server5.3
Type
Usage and Reference
Copyright Date
October 2016
Last Updated
16Feb2017