PROC SQL: Beyond the Basics Using SAS, Second Edition

Chapter 4: Coding PROC SQL Logic

Introduction

Conditional Logic

SQL Code

SQL Code

SQL Code

SQL Code

CASE Expressions

Simple Case Expression

Searched CASE Expression

Case Logic versus COALESCE Expression

Assigning Labels and Grouping Data

Logic and Nulls

Interfacing PROC SQL with the Macro Language

Exploring Macro Variables and Values

Creating Multiple Macro Variables

Using Automatic Macro Variables to Control Processing

Building Macro Tools and Applications

Creating Simple Macro Tools

Cross-Referencing Columns

Determining the Number of Rows in a Table

Identifying Duplicate Rows in a Table

Summary

 

Introduction

Expressions in the SQL procedure can be simple or complex and are represented by a combination of columns, symbols, operators, functions, ...