Contents

Preface

About This Book

About The Author

Chapter 1: Solving Bigger Problems

big data. Big data. BIG DATA

PROC DS2

Problem Space

Clarity

Scope

Modularity and Encapsulation

Data Types

Data Space

Embedded SQL

Threaded Data Access

In-Database Processing

Our First DS2 Programs

PROC DS2 as a DATA Step Equivalent

Chapter 2: Object-Oriented Programming for SAS Programmers

Background and Definition

Dog Class

An Example of OOP

Moving Forward

Chapter 3: Variables and Data Types

Variable Names

DECLARE Statement

DATA Step Conversion—Numerics

DATA Step Conversion—Characters

DATA Step Conversion—Date Types

DATA Step Conversion—Binary Types

DATA Step Conversion—Saving Your Table

More about Dates

Operations and Assignments

IF Operator

SELECT Operator

Arrays

Temporary Arrays

Variable Arrays

Deferred Dimensioning

Array Dimensions

Array Assignment

Missing Values and NULL Values

ANSI Mode and SAS Mode

Testing for Missing or NULL Values

Chapter 4: Scope

Scope

The Program Data Vector (PDV)

KEEP and DROP

Scope in Other Programming Blocks

Chapter 5: Methods

Defining Methods

System-Defined Methods

User-Defined Methods

Recursion

Chapter 6: Packages

User-Defined Packages

Instantiation

Using a Package Variable

Package as Object

Packages and Scope

Package as Method Parameter and Method Return Variable

System-Defined Packages

FCMP Package

TZ Package

Chapter 7: An Example

Problem

The Hash Package

Four Steps to Creation

Lookup and Retrieval

Problem Revisited

Threaded Read

Parameterized Threaded Read

Chapter 8: Data Sources

Overview

Sample Tables

SET

SET Data Set Options

SET with No BY Statement

SET with BY Statement

SET with FedSQL as a Data Source

Merge

Merge with FedSQL as a Data Source

Threads

Thread Methods

Thread Parameters

SQLSTMT Package

SQLSTMT Binding

SQLSTMT – Returning the Rows

References

Index