PROC SQL also supports the ANSI SQL function COALESCE. COALESCE accepts multiple column names of the same ... a subquery must return a single value, that is, one row with only one column. When a ...