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

Course code: DIACS

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.

1 200 EUR

1 452 EUR including VAT

Selection of dates

Do you have a question?

+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

View soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates
Target group
Course structure
Prerequisites

Course dates

Starting date: Upon request

Type: Upon request

Course duration: 14 hours

Language: en

Price without VAT: 1 200 EUR

	Starting date	Place	Type	Course duration	Language	Price without VAT
	Upon request		Upon request	14 hours	en	1 200 EUR	Register
G	Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Target group

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

Course structure

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

Prerequisites

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 SQL 1: Essentials course. You can gain knowledge of SAS from the SAS Programming 1: Essentials course. A working knowledge of your database is helpful.

Do you need advice or a tailor-made course?

product support

+420 731 175 867

edu@edutrainings.cz

The date:
Takes place:
Form:
Language:
Price without VAT: