PROC SQL, 3rd Edition

Chapter 2: Working with Data in PROC SQL

Introduction. 21

The SELECT Statement and Clauses. 21

Overview of Data Types. 23

Numeric Data. 24

Date and Time Column Definitions. 26

Character Data. 27

Missing Values and NULL. 27

Arithmetic and Missing Data. 28

SQL Keywords. 30

SQL Operators, Functions, and Keywords. 31

Comparison Operators. 32

Logical Operators. 33

Arithmetic Operators. 34

Character String Operators and Functions. 36

Summarizing Data. 51

Predicates. 55

CALCULATED Keyword. 63

Dictionary Tables. 66

Dictionary Tables and Metadata. 67

Displaying Dictionary Table Definitions. 68

Dictionary Table Column Names. 69

Accessing a Dictionary Table’s Contents. 72

Summary. 82

 

Introduction

PROC SQL is essentially a database language as opposed ...