Data Management Solutions Using SAS Hash Table Operations : A Business Intelligence Case Study.

Description

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.  Read more... Intro Contents About This Book What 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 Authors Acknowledgments Part One-The HOW of the SAS Hash Object Chapter 1: Hash Object Essentials 1.1 Introduction 1.2 Hash Object in a Nutshell 1.3 Hash Table 1.4 Hash Table Properties 1.4.1 Residence and Volatility 1.4.2 Hash Variables Role Enforcement 1.4.3 Key Variables1.4.4 Program Data Vector (PDV) Host Variables 1.5 Hash Table Lookup Organization 1.5.1 Hash Table Versus Indexed SAS Data File 1.6 Table Operations and Hash Object Tools 1.6.1 Tasks, Operations, Environment, and Tools Hierarchy 1.6.2 General Data Table Operations 1.6.3 Hash Object Tools Classification 1.6.4 Hash Object Syntax 1.6.5 Hash Object Nomenclature 1.7 Peek Under the Hood 1.7.1 Table Organization and Unindexed Key Search 1.7.2 Internal Hash Table Structure 1.7.3 Hashing Scheme 1.7.4 Hash Function 1.7.5 Hash Table Structure and Algorithm in Tandem 1.7.6 The HASHEXP Effect1.7.7 What Is in the Name? Chapter 2: Table-Level Operations 2.1 Introduction 2.2 CREATE Operation 2.2.1 Declaring a Hash Object 2.2.2 Creating a Hash Object Instance 2.2.3 Combining Declaration and Instantiation 2.2.4 Defining Hash Table Variables 2.2.5 Omitting the DEFINEDATA Method 2.2.6 Wrapping Up the Create Operation 2.2.7 PDV Host Variables and Parameter Type Matching 2.2.8 Other Ways of Hard-Coded Parameter Type Matching 2.2.9 Dynamic Parameter Type Matching via File Reference 2.2.10 Parameter Type Matching by Forced File Reference 2.2.11 Parameter Type Matching by Default File Reference2.2.12 Defining Multiple Hash Variables 2.2.13 Defining Hash Variables as Non-Literal Expressions 2.2.14 Defining Hash Variables Dynamically One at a Time 2.2.15 Defining Hash Variables Using Metadata 2.2.16 Multiple Instances Issue 2.2.17 Ensuring Single Instance Usage 2.2.18 Handling Multiple Instances 2.2.19 Create Operation Hash Tools 2.3 DELETE (Table) Operation 2.3.1 The DELETE Method 2.3.2 DELETE Operation Details 2.3.3 Delete (Table) Operation Hash Tools 2.4 CLEAR Operation 2.4.1 The CLEAR Method 2.4.2 Clear Operation vs Delete (Table) Operation2.4.3 CLEAR Operation Hash Tools 2.5 OUTPUT Operation 2.5.1 The OUTPUT Method 2.5.2 Open-Write-Close Cycle 2.5.3 Open-Write-Close Cycle Encapsulation 2.5.4 Avoiding Open File Conflicts 2.5.5 Output Data Set Member Types 2.5.6 Creating and Overwriting Output Data Set 2.5.7 Using Output Data Set Options 2.5.8 DATASET Argument as Non-Literal Expression 2.5.9 Output Data Order 2.5.10 Output Operation Hash Tools 2.6 DESCRIBE Operation 2.6.1 The NUM_ITEMS Attribute 2.6.2 The ITEM_SIZE Attribute 2.6.3 Describe Operation Hash Tools