Tutorial Details: Access and Work With Relational Database Data Through SAS
|Date:||Thursday, April 10, 2008, 01:00 pm - 03:00 pm|
|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|