SAS® 9.4 Cert Prep: Part 02 Accessing Data

Prepare to take the SAS 9.4 certification exam. Learn how to read, access, and import SAS data, in this SAS Institute cert prep course.

Introduction

• Where is your data coming from?

1. Understanding SAS Data

• Types of data
• What is a SAS table?
• Required column attributes for SAS tables
• Listing table and column attributes

2. Accessing Data Through Libraries

• Accessing data in a program
• Using a library to read SAS data
• Automatic SAS libraries
• Demo: Exploring automatic SAS libraries
• Using a library to read Excel files
• Demo: Using a library to read Excel files

3. Importing Data into SAS

• Importing unstructured data
• Demo: Importing a comma-delimited (CSV) file
• Importing an Excel file