Processing Database and PC File Data with SAS/ACCESS Software Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

This Processing Database and PC File Data with SAS/ACCESS Software training course teaches to read data in Database Management System and PC Files within the SAS environment using SAS/ACCESS software.

By attending Processing Database and PC File Data with SAS/ACCESS Software workshop, delegates will learn to:

Read data in relational databases and PC File data using the LIBNAME statement, SQL Pass-Through Facility, and In-Database Processing methods
Import PC Files including Microsoft Excel, Microsoft Access, JMP, STATA, SPSS, and R 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 database for processing
Combine data from different databases using the DATA step and the SQL procedure

Comfortable programming in SAS and Structured Query Language (SQL).

The Processing Database and PC File Data with SAS/ACCESS Software class is ideal for:

SAS programmers that need to access data in Database Management Systems and PC files from within SAS

Introduction

Overview of SAS/ACCESS software
Overview of methods to access data management systems
Connecting to database management

Using the SQL Pass-Through Facility

Creating SQL procedure pass-through queries
Using the SQL pass-through facility
Using the EXECUTE statement

Using the SAS/ACCESS LIBNAME Engine

Using the LIBNAME statement for database management systems
Using the SAS/ACCESS Interface to PC files
Using SAS/ACCESS data set options
Working with PROC SQL views and the embedded LIBNAME statement

Importing and Exporting PC File Data

Importing PC files (MS Excel, MS Access, JMP, R, STATA, and SPSS) with the IMPORT procedure
Exporting data using the EXPORT procedure

Base SAS In-Database Processing

Overview of SAS In-Database Technology
Using Base SAS procedures in database management systems

Performance Considerations

Improving performance with the LIBNAME statement
Combining tables

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

Processing Database and PC File Data with SAS/ACCESS Software