This course teaches you how to read Oracle, DB2, or Microsoft Access or Excel tables into your SAS programs using SAS/ACCESS software.
Learn how to
- read data in relational databases and Excel workbooks using the LIBNAME statement and using the SQL Pass-Through Facility
- create efficiency techniques for optimizing data access performance
- join data using the DATA step and the SQL procedure
- import Microsoft Access and Excel data using the Import Wizard, and export data using the Export Wizard.
Who should attend
Before attending this course, you should be comfortable programming in SAS and Structured Query Language (SQL). You can gain the SQL knowledge from the SAS SQL 1: Essentials course. You can gain knowledge of SAS from the SAS Programming 1: Essentials course. A working knowledge of your database is helpful.
This course addresses SAS/ACCESS software.
This course is appropriate for students who are using SAS 9 software.
Accessing Data in a Relational Database or Microsoft Excel Workbook
Using a SAS/ACCESS LIBNAME Statement
- understanding databases
- establishing the requirements to connect to a database
- establishing the requirements to connect to an Excel workbook
Using the SQL Pass-Through Facility
- connecting to a database table using SAS/ACCESS LIBNAME engines
- connecting to an Excel workbook
- explaining and applying Open Database Connectivity (ODBC)
- using an embedded LIBNAME statement
- passing queries to your database management system (DBMS)
- passing non-queries to your DBMS
- comparing the SQL Pass-Through Facility and the SAS/ACCESS LIBNAME engines
Importing and Exporting PC File Data
- combining tables using a DATA step merge
- joining tables using the SQL Pass-Through Facility and the SQL procedure
- joining tables from different databases
Creating and Updating SAS/ACCESS Access and View Descriptors (Self-Study)
- using the Import Wizard to read a Microsoft Access table and an Excel worksheet into a SAS data set
- Using the IMPORT procedure to read a Microsoft Access table and an Excel worksheet into a SAS data set
- Using the Export Wizard to write a SAS data set and an Oracle table to an Excel workbook
- Using the EXPORT procedure to export a SAS data set to an Excel workbook
- creating and updating an access descriptor
- creating and updating a view descriptor
- converting access and view descriptors to SQL procedure views with the CV2VIEW procedure