PROC SQL: Beyond the Basics Using SAS®

Chapter 4. Coding PROC SQL Logic

4.1	Introduction 110
4.2	Conditional Logic 110
4.3	CASE Expressions 112
	4.3.1 CASE Logic versus COALESCE Expression 114
	4.3.2 Assigning Labels and Grouping Data 116
	4.3.3 Logic and Nulls 118
4.4	Interfacing PROC SQL with the Macro Language 121
	4.4.1 Exploring Macro Variables and Values 121
	4.4.2 Building Macro Tools and Applications 132
4.5	Summary 135