Target group
SAS programmers that need to access data in Database Management Systems and PC files from within SAS
Course structure
Introduction
- course logistics
- overview of SAS/ACCESS software
- syntax for the SQL pass-through facility
- syntax for the SAS/ACCESS LIBNAME statement
Using the SAS/ACCESS Interface to PC Files
- using the IMPORT procedure
- using the EXPORT procedure
- using the SQL pass-through facility
- using the SAS/ACCESS LIBNAME engine
Using the SAS/ACCESS Interface to Oracle
- connecting to Oracle and investigating Oracle metadata
- creating SQL pass-through queries
- using the SAS/ACCESS LIBNAME engine
Using the SAS/ACCESS Interface to DB2
- creating SQL pass-through queries
- using the SAS/ACCESS LIBNAME engine
Using the SAS/ACCESS Interface to Teradata
- creating SQL pass-through queries
- using the SAS/ACCESS LIBNAME engine
Using the SAS/ACCESS Interface to ODBC
- creating an ODBC data source
- accessing an ODBC data source
Additional Data Sources
- accessing additional data sources
Base SAS In-Database Processing
- overview of SAS In-Database technology
- using Base SAS In-Database procedures
Performance Considerations
- improving performance with the LIBNAME statement
