The purpose of this course is to access your DBMS’s via Proc sql.
We look at all kinds of combinations of SAS and DBMS’s, look at performance and options to set up to make your queries run optimal.
There will be a combination of teaching and exercises.
Learn how to
The course deals with accessing SAS and DBMS’ from your preferred SAS editor via Proc sql.
During the cource you will learn:
• Introduction
• Implicit Pass-Through
• Explicit Pass-Through
• Cross-Library Joins•Options
Who should attend
Participants working with SAS and one or more DBMS’, preferably through Proc sql
Formats available | Standard duration | | |
Classroom: |
1 day | | |
|
As a participant of this workshop it is imperative that you have attended the course or have similar experience: SAS SQL1: Essentials
This course addresses Base SAS software.