Cieľová skupina
Táto časť nie je lokalizovaná
SAS programmers that need to access data in Database Management Systems and PC files from within SASŠtruktúra kurzu
Táto časť nie je lokalizovaná
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