Skip to Main Content
Data Management Solutions Using SAS Hash Table Operations
book

Data Management Solutions Using SAS Hash Table Operations

by Paul Dorfman, Don Henderson
July 2018
Beginner to intermediate content levelBeginner to intermediate
400 pages
12h 7m
English
SAS Institute
Content preview from Data Management Solutions Using SAS Hash Table Operations

Chapter 9: Hash of Hashes – Looping Through SAS Hash Objects

9.1 Overview

9.2 Creating a Hash of Hashes (HoH) Table – Simple Example

9.3 Calculating Percentiles, Mode, Mean, and More

9.3.1 Percentiles

9.3.2 Multiple Medians

9.3.3 Percentiles, Mode, Median, and More

9.4 Consecutive Events

9.5 Multiple Splits

9.5.1 Adding a Unique Count

9.5.2 Multiple Split Calculations

9.6 Summary

9.1 Overview

Both our business users and their IT support staff have expressed appreciation for the examples provided so far that allow for parameterization and code generation. They commented positively on being exposed to the macro language and the capabilities of the SQL procedure.

However, they have expressed concern about having to write code for each hash table ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Exchanging Data From SAS to Excel

Exchanging Data From SAS to Excel

William E. Benjamin

Publisher Resources

ISBN: 9781635260595