SAS Programming Advanced Certification Prep Course: 3 in 1

LeeAndro · May 22, 2022

h264, yuv420p, 1280x720 | ENGLISH, aac, 44100 Hz, stereo, s16 | 16h 11 mn | 8.27 GB
Instructor: sharon cheng

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

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

)

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

able 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

)

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

DOWNLOAD
uploadgig

rapidgator

nitroflare

Search

Search

SAS Programming Advanced Certification Prep Course: 3 in 1

LeeAndro

Trusted Editor