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