Efficiency Tips for Database Programming in SAS(R)

Course code: ETDP1F

This class teaches you how to tune your SAS programs for faster execution, especially those that access relational database tables using SAS/ACCESS interfaces or SAS Viya data connectors.

360 EUR

436 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: E-learning

Course duration: 3h 30min

Language: en

Price without VAT: 360 EUR

Starting date: Upon request

Type: Upon request

Course duration: 4 hours

Language: en

Price without VAT: 600 EUR

	Starting date	Type	Course duration	Language	Price without VAT
	Upon request	E-learning	3h 30min	en	360 EUR	Register

	Upon request	Upon request	4 hours	en	600 EUR	Register
G	Guaranteed course

Didn't find a suitable date?

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

Contact

Target group

Data scientists, data analysts, and SAS programmers

Course structure

Foundational Concepts

Introduction.

LIBNAME Access to DBMS Tables

The SAS/ACCESS LIBNAME Engine.
Implicit Pass-Through Basics.
Tuning SAS Programs.
Mitigating Common Problems.
Rules of Thumb for LIBNAME Access.

Working with Multiple Data Sources

Cross-Library Operations.
Accelerating Cross-Library Operations.

The SQL Pass-Through Facility

Implicit versus Explicit Pass-Through.
Explicit Pass-Through with PROC SQL.
Explicit Pass-Through with PROC FEDSQL.

Accessing Database Tables in CAS

Introduction to CAS.
SQL Pass-Through in CAS.
Working with CAS Tables.

Prerequisites

Before attending this course, you should either have at least six months of experience writing SAS programs that include PROC SQL code or have completed the SAS SQL 1: Essentials course and used PROC SQL in SAS for at least one month. The course builds on concepts presented in both the SAS Programming 1: Essentials and SAS SQL 1: Essentials courses, and it is not recommended for beginning SAS software users. Specifically, you should be able to:

Access existing SAS data libraries using a LIBNAME statement.

Write and submit SAS programs to access and manipulate data using the DATA step and PROC SQL.

Read and interpret the SAS log.

Diagnose and correct syntax errors in SAS.