تفاصيل الدورة
This course was updated on 01/2017.
Please Note:
The course's provider is Sharon @ SC statistical programming (formerly treehouse of SAS programming, which is replaced by SC statistical programming).
I have the SAS software licence, which allows me to create and sell video-based SAS programming online courses.
Course Description:
Are you having fun learning SAS Programming on Proc SQL: Part 1? Are you excited about completing the extremely useful SAS programming skill on Proc SQL? Here is the second part of the SAS Programming on Proc SQL courses: SAS Programming on Proc SQL: Part 2.
This course is an intermediate level course. With SAS Programming on Proc SQL: Part 1, it is designed to help you master Proc SQL programing skills and also help prepare you for the SAS certification exams.
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 workforces. 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.
As the same as my other SAS programming courses, this course provides ultimate easy-to-learn environment to make your learning efficient:
- Each lecture shows hands-on coding in SAS programming environment as well as detailed step-by-step explanations
- The course supplements (including SAS codes and data used in lectures) are in their own formats and stored in Zip folders for easy downloading
- The SAS code and data are compatible across all SAS programming environments.
REFERENCE:
SAS 9.4 SQL Procedure User's Guide, Second Edition
SAS certification prep guide: advanced programming for SAS 9 by SAS Institute
تحديث بتاريخ 20 October, 2016- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Microsoft Powerpoint International Open Academy20 USD
79 USDمدة الدورة التدريبية: 30 Hours - Windows Operating System Fundamentals Global Edulink100 USD
707 USDمدة الدورة التدريبية: Upto 22 Hours - 2,967 USDمدة الدورة التدريبية: 12 Weeks دورة إفتراضية أونلاين