SAS/ACCESS Interface to ODBC supports temporary tables. For more information, see Temporary Table Support for SAS/ACCESS.