Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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