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 1SAS Programming on Proc SQL part 2(The contents of this course is also included in SAS Programming Advanced Certification Prep Course: 3 in 1, which is a combined course with 4 individual courses. If you purchased SAS Programming Advanced Certification Prep Course: 3 in 1, you don’t need to purchase this course)step by step/ code by code explanations for easy and efficient learningdownloadable 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 1SAS Programming on Proc SQL part 2This 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) InstallationProc SQL Overview / IntroductionSELECT Statement: Retrieving Data from a Single TableJOINS: Retrieving Data from Multiple Tables using JoinsSUBQUERIES: Using Subqueries to Select DataCombine Queries with Set Operators (UNION, EXCEPT, INTERSECT, OUTER UNION etc.)Creating and Updating Tables and ViewsPractical 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 InstituteNote: A SAS software licence allows SC statistical programming to create and sell video-based SAS programming online courses.