Proc SQL Course (Part 2)

This course is the second part of the SAS Programming on Proc SQL course.

It is an intermediate level course. It is designed to help you master Proc SQL programing skills and also help prepare you for the SAS certification exams.

Fee: $35

Rating: 5.0

30 Days
(money-back guarantee)

Learn Proc SQL Now

About This Course

In this course, you will continue learning essential SAS Proc SQL programming skills on Creating and Updating Tables and Views including Creating table, Inserting Rows into Tables, Updating Data Values in a Table, Deleting Rows, Altering Columns, Deleting a Table, Using SQL Procedure Tables in SAS Software, and Creating and Using PROC SQL Views.

This course also includes a section on Practical Examples Using PROC SQL, which collects common examples often encountered in workforce.

The practical Proc SQL example includes Comparing Old and New Tables, Overlaying Missing Data Values, Computing Percentages within Subtotals, Counting Duplicate Rows in a Table, Expanding Hierarchical Data in a Table, Summarizing Data in Multiple Columns, Creating a Summary Report, Creating a Customized Sort Order, Updating a Table with Values from Another Table.

Learn Proc SQL Now

Who is this class for?

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 or 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 SAS Programming Certification Exams

Learn Proc SQL Now

Requirements

Students or professionals who plan to take this course need to have basic knowledge about SAS base programming.

You can learn SAS base programming here.

Learn Proc SQL Now

Instructor

Sharon Cheng

Online Instructor at SCStatisticalProgramming.com

Learn Proc SQL Now

Course Outline

Section 1: Course Overview and Supplements
Section 2: Creating and Updating Tables and Views
Section 3: Practical Examples Using PROC SQL

Learn Proc SQL Now

Disclosure: we are an affiliate for the course we recommended on this page. We will receive a commission if you purchase a course through our links.

Master SAS in 30 Days

Start your Free training now!