The keyword CASE is always reserved; its use in the CASE expression (an SQL2 feature) precludes its use as a column name. If you have a column named CASE in a table and you want to specify it in a ...

Proc sql can also use the pass-through facility, which allows you to send SQL statements directly to an external database server, bypassing the SAS engine and minimizing the data transfer.