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.
Introduction to SAS Programming with PROC SQL
Duration
1 Day
Course
PLSA-145
Available Formats
Classroom Training
Course Description
Overview
This course is designed to introduce SAS programming with the SQL procedure to new and experienced SAS users.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
- Write programs using the SQL procedure that can query data sources for specific rows and columns
- Join data sets in a number of different ways
- Compare SAS programs using the SQL procedure and the DATA step
Audience
- New SAS Users
- Experienced SAS Users who want to learn about programming with the SQL procedure
Topics
- Course Overview
- Course Data
- Overview of the SELECT statement
- Selecting Columns from a Table
- Creating New Columns
- Sorting Data
- Retrieving Rows
- Grouping Data
- Introduction to Joins
- Combining Queries with SET Operators
- Creating Tables
- Finding the best customers in a retail application
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.