Detail kurzu

Processing Database and PC File Data with SAS/ACCESS(R) Software

EDU Trainings s.r.o.

Popis kurzu

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.

Obsah kurzu

Introductioncourse logisticsoverview of SAS/ACCESS softwaresyntax for the SQL pass-through facilitysyntax for the SAS/ACCESS LIBNAME statementUsing the SAS/ACCESS Interface to PC Filesusing the IMPORT procedureusing the EXPORT procedureusing the SQL pass-through facilityusing the SAS/ACCESS LIBNAME engineUsing the SAS/ACCESS Interface to Oracleconnecting to Oracle and investigating Oracle metadatacreating SQL pass-through queriesusing the SAS/ACCESS LIBNAME engineUsing the SAS/ACCESS Interface to DB2creating SQL pass-through queriesusing the SAS/ACCESS LIBNAME engineUsing the SAS/ACCESS Interface to Teradatacreating SQL pass-through queriesusing the SAS/ACCESS LIBNAME engineUsing the SAS/ACCESS Interface to ODBCcreating an ODBC data sourceaccessing an ODBC data sourceAdditional Data Sourcesaccessing additional data sourcesBase SAS In-Database Processingoverview of SAS In-Database technologyusing Base SAS In-Database proceduresPerformance Considerationsimproving performance with the LIBNAME statement

Cílová skupina

SAS programmers that need to access data in Database Management Systems and PC files from within SAS
Certifikát Na dotaz.
Hodnocení




Organizátor