PROC SQL: Beyond the Basics Using SAS®

4.5. Summary

1. A CASE expression is a PROC SQL feature that can be used to evaluate whether a particular condition has been met (see section 4.3).

2. A CASE expression can be used to process a table’s rows (see section 4.3).

3. A single value is returned from its evaluation of each row in a table (or view) (see section 4.3).

4. Logic conditions can be combined using the logical operators AND and OR (see section 4.3.3).

5. A missing or null value is returned when an ELSE expression is not specified and each when-condition is “false” (see section 4.3.3).

6. A missing value is not the same as a value of 0 (zero) or as a blank character since it represents a unique value or a lack of a value (see section 4.3.3).

7. PROC SQL can be used with the SAS macro facility to perform ...