title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Advanced SAS Programming with PROC SQL
Duration
1 Day
Course
PLSA-150
Available Formats
Classroom Training
Course Description
Overview
This course is designed to introduce experienced SAS users to advanced techniques in the SAS System, especially the SQL procedure.Objectives
Upon completion of the course, students will be able to:
- Write more efficient programs as well as utilize more features of the SQL procedure
Audience
- Students who have been exposed to the SQL syntax, and want to learn more about the SAS SQL procedure
Prerequisites
- Introduction to SAS Programming with PROC SQL
- Basic SQL knowledge
Topics
- Overview of Proc SQL
- Using Subqueries
- Using Correlated Subqueries
- Introduction to Indexes
- Creating and Deleting Indexes
- Creating and Using SQL Views
- Using Options to Debug Queries
- Improving Query Performance
- Using the Macro Facility with Proc SQL
- The Environment
- Six Steps to Building a Data Mart
- Accessing Oracle Tables
- Accessing DB2 Tables
- Accessing Oracle Tables
- SAS Enhancements to SAS/ACCESS
- Maintaining Tables
- Using Dictionary Tables
- Comparing Tables
- Counting Duplicate Rows in a Table
- Using ODS with Proc SQL
Related Courses
-
SAS 1: Introduction to the SAS System
PLSA-115- Duration: 3 Days
- Delivery Format: Classroom Training
- Price: 2,100.00 USD
-
Introduction to Angular
WDJS-300- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 1,755.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.