Evaluating expressions with parentheses begins at the deepest level of parentheses and moves outward. For example, SAS evaluates A+B*C as A+ ... Use the MAX function in a subquery instead of the ALL ...

As a result, you can now create a PROC SQL view, DATA step view, or SAS/ACCESS view with DBMS data. For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL ...