If you omit the CONNECT statement, an implicit connection is performed (by using default values for all database connection arguments) when the first EXECUTE statement is passed to the DBMS. See your ...

Attempting to use reserved keywords (like date, order, etc.) as column aliases in SQL queries causes syntax errors. This is because the database parser interprets the keyword incorrectly.

PROC SQL supports multiple connections to ODBC. If you use multiple simultaneous connections, you must use the alias argument to identify the different connections. If you do not specify an alias, the ...