If DEFER=NO, the connection to the DBMS occurs when the CONNECT statement occurs. VALIDVARNAME=V6 indicates that only those variable names considered valid SAS variable names in Version 6 of SAS ...

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 ...