University of Minnesota
University Relations

Minnesota Supercomputing Institute

Log out of MyMSI

Tutorial Details: Access and Work With Relational Database Data Through SAS

Date: Thursday, April 10, 2008, 01:00 pm - 03:00 pm
Location: 402 Walter
Instructor(s): Haoyu Yu, MSI

In this tutorial, we will introduce some common approaches to the extraction of data in relational databases.

The SAS/ACCESS interface provides methods to access relational database data. We will discuss how we can use these methods to interact with data residing on a remote server, say in an Oracle database.

We will also introduce the SAS SQL procedure and learn how to complete many tasks with a single SQL statement while a more traditional SAS approach may involve several SAS procedures and DATA steps.

Prerequisites: Basic knowledge of SQL and SAS