alias specifies an alias for table-name. sql-expression is described in sql-expression. table-name can be one of the following: the name of a PROC SQL table. the name of a SAS data view. a ...

The CASE expression selects values if certain conditions are met. A CASE expression returns a single value that is conditionally evaluated for each row of a table (or view). Use the WHEN-THEN clauses ...