The SQL statement may be case-sensitive, depending on your DBMS, and it is passed to the DBMS exactly as you type it. Any return code or message that is generated by the DBMS is available in the macro ...

Column names can be case-sensitive also ... By specifying DQUOTE=ANSI and double quoting the SAS names in the SELECT statement, the special characters are preserved in the output. proc sql dquote=ansi ...