Using SAS/ACCESS^® Interface to ODBC in SAS 9.1.3 with the Microsoft Access ODBC driver may result in the following error:

ERROR: PROC SQL requires any created table to have at least 1 column.

This may happen using a UNION clause on 3 or more Microsoft Access tables. This is due to a Microsoft ODBC driver bug. A workaround would be to add the following option to the LIBNAME statement:

DIRECT_SQL=NO