Dorfman P., Henderson D. Data Management Solutions Using SAS Hash Table Operations: A Business Intelligence Case Stud

Cary: SAS Institute, 2018. — 399 p.Hash tables can do a lot more than you might think! Data Management Solutions Using SAS Hash Table Operations: A Business Intelligence Case Study concentrates on solving your challenging data management and analysis problems via the power of the SAS hash object, whose environment and tools make it possible to create complete dynamic solutions. To this end, this book provides an in-depth overview of the hash table as an in-memory database with the CRUD (Create, Retrieve, Update, Delete) cycle rendered by the hash object tools. By using this concept and focusing on real-world problems exemplifie.About This BookWhat Does This Book Cover?Is This Book for You?How to Read This Book
What Are the Prerequisites for This Book?
What Should You Know about the Examples?
Software Used to Develop the Book's Content
Example Code and Data
SAS University Edition
We Want to Hear from You
About These AuthorsThe HOW of the SAS Hash Object
Hash Object EssentialsHash Object in a Nutshell
Hash Table
Hash Table Properties
Residence and Volatility
Hash Variables Role Enforcement Key Variables Program Data Vector (PDV) Host Variables
Hash Table Lookup Organization
Hash Table Versus Indexed SAS Data File
Table Operations and Hash Object Tools
Tasks, Operations, Environment, and Tools Hierarchy
General Data Table Operations
Hash Object Tools Classification
Hash Object Syntax
Hash Object Nomenclature
Peek Under the Hood
Table Organization and Unindexed Key Search
Internal Hash Table Structure
Hashing Scheme
Hash Function
Hash Table Structure and Algorithm in Tandem The HASHEXP Effect What Is in the Name?
Table-Level OperationsCREATE Operation
Declaring a Hash Object
Creating a Hash Object Instance
Combining Declaration and Instantiation
Defining Hash Table Variables
Omitting the DEFINEDATA Method
Wrapping Up the Create Operation
PDV Host Variables and Parameter Type Matching
Other Ways of Hard-Coded Parameter Type Matching
Dynamic Parameter Type Matching via File Reference
Parameter Type Matching by Forced File Reference Parameter Type Matching by Default File Reference Defining Multiple Hash Variables
Defining Hash Variables as Non-Literal Expressions
Defining Hash Variables Dynamically One at a Time
Defining Hash Variables Using Metadata
Multiple Instances Issue
Ensuring Single Instance Usage
Handling Multiple Instances
Create Operation Hash Tools
DELETE (Table) Operation
The DELETE Method
DELETE Operation Details
Delete (Table) Operation Hash Tools
CLEAR Operation
The CLEAR Method Clear Operation vs Delete (Table) Operation CLEAR Operation Hash Tools
OUTPUT Operation
The OUTPUT Method
Open-Write-Close Cycle
Open-Write-Close Cycle Encapsulation
Avoiding Open File Conflicts
Output Data Set Member Types
Creating and Overwriting Output Data Set
Using Output Data Set Options
DATASET Argument as Non-Literal Expression
Output Data Order
Output Operation Hash Tools
DESCRIBE Operation
The NUM_ITEMS Attribute
The ITEM_SIZE Attribute
Describe Operation Hash Tools