See PROC SQL and the ANSI Standard for more information. For an example that uses COALESCE, see Performing an Outer Join. The order in which operations are evaluated is the same as in the DATA step ...