h264, yuv420p, 1280x720 | ENGLISH, aac, 44100 Hz, stereo, s16 | 16h 11 mn | 8.27 GB
Instructor: sharon cheng
Suitable for both traditional & new practical advanced certificate: SAS Macro,SAS SQL,Advanced Techniques & Efficiencies

What you'll learn

Master SAS SQL (Proc SQL) programming
Proc SQL Overview
SELECT Statement: Retrieving Data from a Single Table
JOINS: Retrieving Data from Multiple Tables using Joins
SUBQUERIES: Using Subqueries to Select Data
Combine Queries with Set Operators (UNION, EXCEPT, INTERSECT, OUTER UNION etc.)
Creating and Updating Tables and Views
Practical Examples Using PROC SQL (9 practical examples)

Requirements

basic knowledge about SAS programming

Description

Course Highlights:

This course contains all the essential SAS SQL programming techniques to help you master SAS Proc SQL programming skills and also help prepare you for the SAS certification exams.

A combined course (9 hours video-based lectures, 67 lectures), which contains the following two individual courses to provide the maxim benefit for my students:

SAS Programming on Proc SQL part 1

SAS Programming on Proc SQL part 2

step by step/ code by code explanations for easy and efficient learning

downloadable data, SAS programs and Power Point slides used in the course (the course materials are ONLY for practice, they are protected by copyright)

Quizzes, coding exercises and practical examples. After all, practice makes perfection!

Notes on Course ratings and reviews:

Please be considerate and sincere when you provide ratings. This will encourage me providing more contents to the course and better service to you! Please provide fair ratings to this course with the consideration of the comparison among other available SAS advanced courses.

Course Description:

This course is a combined course, which contains the following two individual courses to provide the maxim benefit for my students:

SAS Programming on Proc SQL part 1

SAS Programming on Proc SQL part 2

This is an intermediate level course. It contains all the SAS SQL programming essential techniques to help you master SAS Proc SQL programming skills and also help prepare you for the SAS certification exams.

This course include 7 sections (Please see course curriculum for more detailed information on lectures included in each section)

Course Overview, Course Supplements, SAS University (SAS Studio) Installation

Proc SQL Overview / Introduction

SELECT Statement: Retrieving Data from a Single Table

JOINS: Retrieving Data from Multiple Tables using Joins

SUBQUERIES: Using Subqueries to Select Data

Combine Queries with Set Operators (UNION, EXCEPT, INTERSECT, OUTER UNION etc.)

Creating and Updating Tables and Views

Practical Examples Using PROC SQL (9 practical examples)

REFERENCE:

SAS 9.4 SQL Procedure User's Guide, Second Edition

SAS certification prep guide: advanced programming for SAS 9 by SAS Institute

Note: A SAS software licence allows SC statistical programming to create and sell video-based SAS programming online courses.
Who this course is for:

Students or professionals who wants to learn SAS Proc SQL programming skills, which are highly demanded skills in SAS and statistics industry
Students and Professionals who wants to become an advanced SAS programmer, and be more demanded and successful in their SAS career
Students or professionals who wants to take Advanced SAS Programming Certification Exams
[i][/i]Screenshots