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 statementCí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
Podobné kurzy
podle názvu a lokality