• Print |
• E-mail  |
• Bookmark

Temporary database table use requires two libname statements to share a
single connection to the database:

* One libname statement contains the option DBMSTEMP=YES that creates
and references the temporary table.
* The other libname statement references the database table.
* Both libname statements contain the option CONNECTION=GLOBAL, thereby
allowing one connection to be shared between two librefs to the
database.

To perform a database join with a temporary database table:

1. Establish a sharable connection using the CONNECTION=GLOBAL option to
the database.
Note: Clearing both librefs closes the global connection and drops all
database upload tables.
2. Create a database temporary table and load it with the SAS data.
3. (Optional) Run statistics on the newly-created table to allow the
optimizer to do the join more efficiently.
Note: Might need to contact the DBA for permissions.
4. Perform a join on the database.
5. Process the join result with SAS.
6. Optionally drop the temporary database table

Operating System and Release Information