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.
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 Can Benefit
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(R) SQL 1: Essentials course. You can gain knowledge of SAS from the SAS(R) Programming I: Essentials course. A working knowledge of your database is helpful.
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
https://www.exitcertified.com/it-training/sas/sas-data-management/sas-access/-50714-detail.htmlDIACSProcessing Database and PC File Data with SAS/ACCESS(R) Softwarehttps://assets.exitcertified.com/assets/CourseImages/1371f48ca1/AdobeStock_193300942__FitMaxWzEwMDAsMTAwMF0.jpg1300.00USDInStock/Training/SAS/Data Management/SAS/ACCESS This course teaches you how to process data using SAS/ACCESS software. Databases and PC files covered in this course are...1300.00SASClassroom2017-02-07T03:12:10+00:00USD