SAS Programming Advance Certification Course(SAS SQL,Macro)

SAS Programming Advance Certification Course(SAS SQL,Macro)



The complete Prep Course for SAS Advanced Programming Professional Certification SAS® 9.4 (Exam ID A00-232, A00-234)



上次更新 11/2020



英语 [自动]

20 个章节 • 144 个讲座 • 总时长 14 小时 22 分钟

https://www.udemy.com/course/sas-programming-on-proc-sql-part2/

你将会学到的



Suitable for both the traditional SAS® Certified Advanced Programmer for SAS®9 and the new practical SAS® Certified Professional: Advanced Programming Using SAS® 9.4



the most complete SAS Advanced programming certification course



SAS Advanced Programming Techniques and Efficiencies (the only Udemy course contains this content)



SAS SQL (SAS Proc SQL)



SAS Macro



要求



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



说明



Course Highlights:







The complete Preparation Course for SAS Advanced Programming Professional Certification Using SAS® 9.4:







Exam ID A00-232, A00-234







ALL 3 advanced SAS programming topics (SAS Macro, SAS SQL, Advanced Techniques and Efficiencies) in one course (the exam for SAS® Certified Advanced Programmer includes 3 Advanced SAS topics: SAS SQL, SAS Macro, Advanced Programming Techniques and Efficiencies.). This is by far the only Udemy course with contents on Advanced Programming Techniques and Efficiencies!







This course is a combined course to offer the maxim benefit for my students, it includes contents from four individual courses







1. SAS programming on SAS Macro Language







2. SAS programming on Proc SQL part 1







3. SAS programming on Proc SQL part 2







4. Advanced Techniques and Efficiencies







16 hours long and over 135 video-based lectures;







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







easy downloading all the data and SAS programs used in the course (the course materials posted in Lecture 4 are ONLY for practice, they are protected by copyright)







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







Coding exercises and practical examples are perfect for for the practical coding questions in the exam







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!







In this course I combine all SAS advanced topics (SAS SQL, SAS Macro, Advanced programming techniques and efficiencies) in this one big course to let my students have the maxim benefit with their money. This course is a truly cost-value effective one for both individual users and Udemy for business users.







Please provide fair ratings to this course with the consideration of the comparison among other available SAS advanced courses.







Course Description:







Do you want to learn SAS programming advanced topics and become SAS® Certified Advanced Programmer? This course include ALL 3 SAS Advanced programming topics included in the SAS Advanced programming certification exam:







SAS SQL (Proc SQL) : 8 hours long and over 60 video-based lectures (all sections start with "SAS SQL")







SAS Macro Language : 4 hours long and over 40 video-based lectures (all sections start with "SAS Macro")







Advanced Programming Techniques and Efficiencies: 4 hours long and over 35 video-based lectures (all sections start with "Advanced Techniques and Efficiencies")







You may compare the sections and lectures included in this course with the official SAS Advanced certification Exam contents (I am not allowed to include the direct site due to Udemy policy) and SAS Certification Prep Guide: Advanced Programming.







Course Contents: (Please see course curriculum for more detailed information on lectures included in each section)







Install SAS University Edition (SAS studio): the complete & step-by-step guide; detailed explanation on File path/directory in SAS studio







SAS SQL (Proc SQL) : 8 hours long and over 60 video-based lectures:







sections are:







SELECT Statement







JOIN







Subqueries







Combine Queries







Creating and Updating Tables and Views







Practical Examples Using PROC SQL







SAS Macro Language : 4 hours long and over 40 video-based lectures







sections are:







SAS Macro programming introduction:







Create and Use Macro variables and Macro Functions:







Create and Use Macro Programs:







Create and Use macro variables during execution of a data step:







Create and Use macro variables during execution of a proc SQL step:







Advanced Programming Techniques and Efficiencies: 4 hours long and over 35 video-based lectures







sections are:







Advanced Techniques and Efficiencies: Indexes







Advanced Techniques and Efficiencies: Combining Data Vertically







Advanced Techniques and Efficiencies: Combining Data Horizontally







Advanced Techniques and Efficiencies: Formats & Arrays







Advanced Techniques and Efficiencies: Perform effective benchmarking







Advanced Techniques and Efficiencies: Controlling Data Storage Space







Advanced Techniques and Efficiencies: PROC FCMP: functions and subroutines







Advanced Techniques and Efficiencies: Compare techniques to eliminate duplicates















REFERENCE:







SAS 9.4 SQL Procedure User's Guide, Second Edition







SAS® 9.4 Macro Language: Reference, Fifth 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.







此课程面向哪些人：



Students or professionals who wants to learn SAS advanced topics SAS SQL, SAS Macro and SAS Advanced Techniques and Efficiencies programming skills



Students or professionals who wants to take SAS Advanced Programming Certification Exams