PROC SQL: Beyond the Basics Using SAS®

Chapter 2. Working with Data in PROC SQL

2.1	Introduction 24
2.2	Data Types Overview 24
	2.2.1 Numeric Data 24
	2.2.2 Date and Time Column Definitions 27
	2.2.3 Character Data 28
	2.2.4 Missing Values and Null 28
	2.2.5 Arithmetic and Missing Data 29
	2.2.6 SQL Keywords 30
2.3	SQL Operators and Functions 32
	2.3.1 Comparison Operators 33
	2.3.2 Logical Operators 34
	2.3.3 Arithmetic Operators 36
	2.3.4 Character String Operators and Functions 39
	2.3.5 Summarizing Data 52
	2.3.6 Predicates 58
2.4	Dictionary Tables 70
	2.4.1 Displaying Dictionary Table Definitions 71
	2.4.2 Dictionary Table Column Names 72
	2.4.3 Accessing a Dictionary Table’s Contents 76
2.5	Summary 83