Getting the Message Across: Cutting Run Times and Updating Databases with SAS/ACCESS®

Elise Mara
San Francisco Department of Public Health


Abstract

When SAS® communicates with a database, efficient coding can mean the difference between a few minutes and a few hours! It is often easy to find tips on how to read data into and out of Excel spreadsheets, text files, and the like, but for users without experience in database administration or networking, getting SAS to talk to a database may seem like a trickier endeavor. Fortunately, SAS has user-friendly functionality to establish connections, pull data, alter database contents, and take advantage of server resources. This paper will outline how to use ODBC and LIBNAME statements to connect to databases, issue basic SQL procedure commands to perform data selection and manipulation, and craft pass-through queries to have the database server do the heavy lifting for you.