SAS Programming Advance Certification Course(SAS SQL,Macro) (Udemy.com)
The complete Prep Course for SAS Advanced Programming Professional Certification SAS 9.4 (Exam ID A00-232, A00-234)
Created by: sharon cheng
Produced in 2021
What you will learn
- Suitable for both the traditional SAS Certified Advanced Programmer for SAS9 and the new practical SAS Certified Professional: Advanced Programming Using SAS 9.4
- the most complete SASAdvanced programming certification course
- SAS Advanced Programming Techniques and Efficiencies (the only Udemy course contains this content)
- SAS SQL (SAS Proc SQL)
- SAS Macro
Quality Score
Overall Score : 86 / 100
Course Description
The complete Preparation Course for SAS Advanced Programming Professional Certification Using SAS 9.
4: Exam ID A00-232, A00-234ALL 3 advanced SASprogramming 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, SASMacro, 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 courses1. SASprogramming on SASMacro Language2. SAS programming on Proc SQL part 13. SAS programming on Proc SQL part 24. Advanced Techniques and Efficiencies16 hours long and over 135 video-based lectures; step by step/ code by code explanations for easy and efficient learningeasy downloading all the data and SASprograms used in the course (the course materials posted in Lecture 4 are ONLYfor 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 examNotes 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 SASCertified Advanced Programmer? This course include ALL 3 SASAdvanced programming topics included in the SASAdvanced 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 Advancedcertification 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 studioSAS SQL (Proc SQL) : 8 hours long and over 60 video-based lectures:
sections are:
SELECT StatementJOINSubqueriesCombine QueriesCreating and Updating Tables and Views Practical Examples Using PROC SQL SAS Macro Language : 4 hours long and over 40 video-based lecturessections 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 lecturessections are:
Advanced Techniques and Efficiencies: IndexesAdvanced Techniques and Efficiencies: Combining Data VerticallyAdvanced Techniques and Efficiencies: Combining Data HorizontallyAdvanced Techniques and Efficiencies: Formats & ArraysAdvanced Techniques and Efficiencies: Perform effective benchmarkingAdvanced Techniques and Efficiencies: Controlling Data Storage SpaceAdvanced Techniques and Efficiencies: PROC FCMP: functions and subroutinesAdvanced Techniques and Efficiencies: Compare techniques to eliminate duplicatesREFERENCE: 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 InstituteNote: A SAS softwarelicenceallows 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 advanced topics SAS SQL, SAS Macro and SAS Advanced Techniques and Efficiencies programming skillsStudents or professionals who wants to take SAS Advanced Programming Certification Exams
Instructor Details
- 4.3 Rating
77 Reviews
sharon cheng
Welcome to SC Statistical Programming!
Before I become an online SAS programming instructor, I have worked as a statistician/SAS programmer for 7 years. I am a SAS certified professional and highly proficient in SAS programming, and I enjoy teaching as well. Now I would like to use my SAS programming skills to help people learning SAS in an easy and affordable way.
I created my business SC Statistical Programmingto offer free SAS programming courses and tutorial videos and coding articles, as well as affordable online video-based SAS programming courses at various levels. No matter you are a beginner or experienced professional in SAS programming, all courses are designed to help you learn SAS programming easy and efficiently.
Information about my current published courses:
A SAS BASE certificate course for absolute SAS Beginners
SAS Advanced Certificate: SAS SQL, SAS Macro & Advanced Tech
SAS Programming on Report and Table Generating
All courses offer:
1. Lifetime access 24/7; 30 days money back guarantee!
2. Each lecture/video shows hands-on coding in SAS programming environment as well as detailed step-by-step and code-by-code explanations
3. The course supplements (including SAS codes and data used in lectures) are in their own formats and stored in Zip folders for easy downloading
4. The SAS code and data are compatible across all SAS programming environments
5.
More courses by sharon cheng
SAS Programming BASE certification course for SAS Beginners (2021)
4.2 (304 Reviews)
Provider: Udemy
Time: 12.5h
$11.99
More sql courses
SQL Server - zapytania. Querying. Exam 70-761 (2021)
4.8 (99 Reviews)
- Provider: Udemy
- Time: 5h
$11.99
Oracle Database 12c SQL Certified Associate 1Z0-071 (2021)
4.7 (336 Reviews)
- Provider: Udemy
- Time: 20h
$11.99
Introduction to Structured Query Language (SQL) (2017)
4.7 (313 Reviews)
- Provider: Coursera
- Time: 3h
Free
Learn C# With Windows Forms and SQL Server (2021)
4.7 (269 Reviews)
- Provider: Udemy
- Time: 12.5h
$11.99
Microsoft Access SQL: SQL for Non-Programmers (2021)
4.7 (240 Reviews)
- Provider: Udemy
- Time: 3.5h
$11.99
Reviews
- Video Duration:
14h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
