This course teaches you how to process data using SAS/ACCESS software. Databases and PC files covered in this course are Microsoft Excel, Microsoft Access, Oracle, DB2, Teradata, and Microsoft SQL Server via ODBC. Also included is a brief discussion about Hadoop, JMP, dBase, STATA, SPSS, and R.
Learn how to
- process relational database data and PC file data using the LIBNAME statement, SQL pass-through facility
- import PC file data using the IMPORT procedure, as well as export data using the EXPORT procedure
- use In-Database Processing methods to submit Base SAS procedures to relational database for processing
- improve performance with the SAS/ACCESS LIBNAME statement.
Who should attend
SAS programmers that need to access data in Database Management Systems and PC files from within SAS
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.