This course includes:
- 12.5 hours on-demand video
- downloadable resources
- 2 practice tests
- Full lifetime access
- Access on mobile devices
- Assignments
-
Certificate of completion
Aslam Khan
Meet your expert trainer for this course!
A certified Program Management Professional (PgMP), Project Management Professional (PMP) and a SAS Base and Advanced Certified Programmer, with a Master's Degree in Management Information Systems, Alsam will guide you through the sometimes complex concepts by breaking them down using simple illustrations and easy to understand language. His very intuitive approach will ultimately help you understand, learn and retain the topics of interest.
Expert Support Available!!!
In this course you will be able to interact with the trainer for valuable help. The course contains video lessons, quizzes and assignments that may be tricky at times. Ask the expert trainer directly for support, suggestions, clarifications or even curiosities!
He will get back to you in a timely manner and you may trigger an interesting conversation.
What you'll learn
- Perform Data Analysis with the powerful SAS programming language
- Learn SAS in the most effective way through simple, visual and engaging lectures
- SAS Certified Associate: Programming Fundamentals Using SAS 9.4 (Exam ID: A00-215)
- SAS Certified Professional: Advanced Programming Using SAS 9.4
- SAS Certified Specialist: Base Programming Using SAS 9.4 (Exam ID: A00-231)
- SAS Certified Clinical Trials Programmer Using SAS®9
- Acquire the skills to import any type of Data into SAS and construct meaningful reports out of it
- Analyze data with powerful SAS procedures that reveal amazing insights within your data
- Learn to create beautiful visualizations and reports to present to all kinds of audience
- Strengthen your foundation to appear for SAS Base and Advanced certification exams
- Have fun by playing around with exercise data all along the course lectures
- Apply all topics learnt and finish the project at the end of the course on your own
-
Start a discussion on any course topic, ask questions and share your course accomplishments as you go along
Requirements
- Basic knowledge of working with a computer, typing and editing skills.
- Internet connectivity to work in SAS Studio
- Since this course is highly visual in nature, this is not suitable for audio listening only
Who this course is for
- Individuals looking to quickly acquire data manipulation and data analytics skills, to get placed in job roles that involve a lot of data processing, or as part of data science university coursework. This course uses SAS University Edition as the software tool to work with data.
- Stepping into the world of data science and data analytics
- Want to "spring-board" to take on the next level in SAS Programming, or just getting motivated to play with data
- Want to learn the elementary and advanced concepts in SAS Programming
- Want to pass the Base SAS or Advanced SAS Certification
- Students of Statistics who wish to learn a tool for their coursework
Earn a Certificate
When you finish listening to all videos, assignments, quizzes and practice exams, you'll earn a Certificate that you can share with prospective employers and your professional network.
Description
A comprehensive, simple and visual guide to Data Analysis using SAS Programming, this course is simplified into the 4 main areas: Data Preparation, Data Structuring, Data Visualization and Optimizing Code using powerful SAS Macros.
- This course is for absolute beginners as well as advanced users who wish to learn SAS Programming
- Delivered in a highly visual style, you will experience a unique and immersive method of the lectures
- Equips you with the cutting-edge tool used in many industries, primarily in Pharma, Finance and Insurance areas
- Simplified to just 4 main areas, this course is an accelerated path to learning SAS programming
- A guide to the following SAS certification exams:
- SAS Certified Associate: Programming Fundamentals Using SAS 9.4 (Exam ID: A00-215)
- SAS Certified Specialist: Base Programming Using SAS 9.4 (Exam ID: A00-231)
- SAS Certified Professional: Advanced Programming Using SAS 9.4
- SAS Certified Clinical Trials Programmer Using SAS®9
- Super easy to to start using SAS with no installation on your computer necessary. All you need is a web browser and a good internet connection. This course uses the latest SAS Studio offered through SAS OnDemand and is completely Free to use !
- 12+ hours of knowledge-packed lectures, 117 videos, 65 Quiz questions and 2 Practice Tests, followed by 2 practical and hands-on guided exercises and projects
Course Curriculum
Section 1: Course Introduction and Overview on SAS
Available in
days
days
after you enroll
Section 2: Getting started with SAS Programming
Available in
days
days
after you enroll
Section 3: Preparing Data
Available in
days
days
after you enroll
- 6. Preparing Data - Section Overview (0:57)
- 7. SAS Datasets Variables and Observations (8:44)
- Resource - Myclass
- 8. SAS Libraries (4:50)
- 9. Library Naming Conventions (4:48)
- 10. SAS Dataset naming conventions (4:05)
- 11. SAS Program Syntax (6:57)
- Resource - Cars
- 12. SAS Data Step and Proc Step (2:35)
- Resource - Cars
- 13. Referencing data in SAS (4:18)
- Resource - Cars
- QUIZ 2: Elements
- 14. Bringing data into SAS (11:48)
- 15. Bringing data into SAS using Import Wizard (3:45)
- Resource - Bringing data into SAS mycars
- 16. Bringing data into SAS using LIBNAME statement (5:14)
- Resource - SAS using LIBNAME (1:53)
- 17. Bringing data into SAS using FILENAME (5:07)
- Resource - SAS using FILENAME
- QUIZ 3: Bringing data into SAS
- Assignment 1: Bringing data into SAS
- Assignment 1: Bringing data into SAS - Instructor Example
- 18. Bringing data into SAS using DELIMITER option (3:19)
- Resource - Delimiter
- Assignment 2: Bringing data into SAS using Delimiter option
- Assignment 2: Bringing data into SAS using Delimiter option - Instructor Example
- 19. Bringing data into SAS using DSD option (7:36)
- Resource - Dsd delimiter
- 20. Bringing data into SAS using column input (4:02)
- Resource - Column input
- 21. Bringing data into SAS using the column pointer @ symbol (1:53)
- Resource - Column pointer
- 22. Bringing data into SAS using the line pointer # symbol (7:10)
- Resource - Line pointer
- 23. Bringing data into SAS using the line slash symbol (2:25)
- Resource - Slash symbol
- 24. Bringing data into SAS using the trailing @ symbol (3:09)
- Resource - Single trailing at symbol
- 25. Bringing data into SAS using the trailing @@ symbol (2:26)
- Resource - Double trailing at symbol
- QUIZ 4: Bringing Data into SAS Advanced Methods
- Assignment 3: Bringing data into SAS using advanced options
- Assignment 3: Bringing data into SAS using advanced options - Instructor Example
- 26. Bringing data into SAS using Proc Import XLS (MS Excel) (6:48)
- Resource - Proc Import - Class
- 27. Bringing data into SAS using Proc Import TXT Files (4:48)
- Resource - Proc+Import+ - Class - Classtab
- QUIZ 5: Bringing data into SAS using Import procedure
- Assignment 4: Get "berries" data into your SAS session
- Assignment 4: Get "berries" data into your SAS session - Instructor Example
- 28. Creating new variables (4:08)
- 29. Creating new variables - coding exercise (8:23)
- Resource - New Variables
- 30. Keeping, Dropping and Renaming Variables in a Dataset (2:59)
- Resource - Keep, Drop, Rename
- Assignment 5: Conditional logic and filtering data
- Assignment 5: Conditional logic and filtering data - Instructor Example
- 31. If-else conditional statements - deriving BMI variable (4:11)
- 32. If-else conditional statements - deriving STATUS variable (11:26)
- Resource - If else
- 33. Filtering data (11:17)
- Resource - Filtering
- QUIZ 6: New variables, conditional logic
- Assignment 6: Finding the most expensive cars
- Assignment 6: Finding the most expensive cars - Instructor Example
- 34. SAS dates (6:48)
- Resource - Sas dataset
- 35. SAS Character functions - Upcase function (9:39)
- Resource - Char Function
- 36. SAS Character functions - Lowcase, Propcase, Len, Cat functions (7:54)
- 37. SAS Character functions - Substr function (4:27)
- Resource - Char Function Substr
- 38. SAS Character functions - Trim, Left, Strip, Compress, Compbl functions (12:42)
- 39. SAS Character functions - Scan function (1:50)
- 40. SAS Character functions - Index functions (6:34)
- 41. SAS Numeric functions - Sum function (7:12)
- 42. Null Dataset (3:36)
- 43. SAS Numeric functions - Abs function (1:36)
- 44. SAS Numeric functions - Ceiling, Floor and Integer functions (3:42)
- 45. SAS Numeric Functions - Minimum and Maximum functions (1:40)
- QUIZ 7: SAS Dates and SAS Functions
- Assignment 7: Applying SAS Functions
- Assignment 7: Applying SAS Functions - Instructor Example
- 46. SAS Formats - Introduction (2:50)
- 47. SAS Format Statement (5:20)
- 48. Format Naming Convention (9:13)
- 49. Format using PUT function (8:50)
- Resource - Formats
- 50. SAS Informats (6:21)
- 51. SAS Informats - code (7:32)
- Resource - Informats
- 52. Custom formats using Proc Format (5:28)
- 53. Custom formats using Proc Format - code (11:07)
- Resource - Proc+format
- QUIZ 8: Formats in SAS
- Assignment 8: Applying SAS formats
- Assignment 8: Applying SAS formats - Instructor Example
- 54. Program Data Vector (PDV) (5:43)
- 55. PDV Implicit Output - Descriptor portion (4:52)
- 56. PDV Implicit Output - var data portion (9:36)
- 57. PDV Explicit Output (6:00)
- 58. PDV Explicit Output - code (11:01)
- Resource - PDV
- 59. Do Loops (4:08)
- Resource - Do Loops
- QUIZ 9: Behind the scenes
- Assignment 9: Using explicit output statement
- Assignment 9: Using explicit output statement - Instructor Example
- Practice test 1: Preparing data
- 60. Guided Exercise - "Project Cars" - Introduction (1:29)
- Assignment 10: "Project Cars" - Exercise 1 (1:25)
- Assignment 10: "Project Cars" - Exercise 1 - Instructor Example
- Assignment 11: Secret SAS Proc revealed!
- Assignment 11: Secret SAS Proc revealed! - Instructor Example
- 61. Preparing data - Section Conclusion (1:08)
Section 4: Structuring Data
Available in
days
days
after you enroll
- 62. Structuring Data - Section Overview (1:08)
- 63. Stacking data using a Data Step (5:35)
- Resource - Data Step
- 64. Stacking data using PROC APPEND (7:48)
- 65. Stacking data using PROC APPEND - code (6:43)
- Resource - Stacking Data Proc Append
- 66. Interleaving data (9:02)
- Resource - Interleaving
- QUIZ 10: Stacking of data
- 67. Sorting data using PROC SORT (7:04)
- 68. Sorting data using PROC SORT- multi-level sorting (6:02)
- Assignment 12: Interleaving Data
- Assignment 12: Interleaving Data - Instructor Example
- 69. Removing duplicates-NODUP option (11:09)
- Resource - Proc Sort Nodup
- 70. Removing duplicates-NODUPKEY option (10:35)
- Resource - Proc Sort Nodupkey
- QUIZ 11: Sorting Data
- Assignment 13: Removing Duplicates
- Assignment 13: Removing Duplicates - Instructor Example
- 71. Simple merging of data (8:42)
- Resource - Merging
- 72. Merging data using Joins-Introduction (7:42)
- 73. Merging data using Joins-Inner Join (8:18)
- 74. Merging data using Inner Join - code (7:52)
- Resource - Inner Join
- 75. Merging data using Full Join (7:13)
- Resource - Full Join
- 76. Merging data using Left Join (6:15)
- Resource - Left Join
- 77. Merging data using Right Join (3:41)
- Resource - Right Join
- 78. Merging data using "Far" Joins (6:26)
- Resource - "Far" Join
- QUIZ 12: Merging data
- Assignment 14: Merging data
- Assignment 14: Merging data - Instructor Example
- 79. Proc SQL - copying data (8:55)
- 80. Proc SQL - copying data - code (4:19)
- Resource - Copying Data
- 81. Proc SQL - filtering data (6:54)
- Resource - Filtering Data
- 82. Proc SQL - sorting data (8:27)
- Resource - Sorting Data
- 83. Proc SQL - removing duplicates (5:27)
- Resource - Removing duplicates
- QUIZ 13: Proc SQL
- Assignment 15: Proc SQL
- Assignment 15: Proc SQL - Instructor Example
- 84. Transposing data - ID statement (3:55)
- 85. Transposing data - ID statement - code (8:06)
- Resource - Transposing
- 86. Transposing data - BY statement (9:40)
- 87. Transposing data - BY statement - code (4:28)
- Resource - Transposing by statement
- QUIZ 14: Transposing Data
- Assignment 16: Transposing Data
- Assignment 16: Transposing Data - Instructor Example
- Resource - Transposing Data
- 88. Retain statement - Introduction (7:23)
- 89. Retain statement - How it is used (6:18)
- Resource - Retain
- 90. Retain statement - Example (8:00)
- Resource - Retain
- Assignment 17: Retain statement
- Assignment 17: Retain statement - Instructor Example
- QUIZ 15: Structuring Data
- Assignment 18 "Project Cars" - Exercise 2 (1:27)
- Assignment 18 "Project Cars" - Exercise 2 - Instructor example (5:55)
- 91. Structuring data - Section Conclusion (0:47)
Section 5: Visualizing Data
Available in
days
days
after you enroll
- 92. Visualizing Data - Section Overview (0:38)
- 93. Charts - Introduction - Vertical Bar Chart (4:46)
- 94. Charts - Horizontal Bar and Pie Charts (4:46)
- 95. Vertical Bar Chart - DISCRETE option (9:36)
- Resource - Chart discrete option vbar
- 96. Horizontal Bar Chart - DISCRETE option (1:27)
- Resource - Chart discrete option hbar
- 97. Vertical Bar Chart - groups and subgroups (11:28)
- Resource - Chart group and subgroup vbar
- 98. Horizontal Bar Chart - groups and subgroups (3:13)
- Resource - Chart group and subgroup hbar
- 99. Plots (4:36)
- Resource - Plot
- Assignment 19: Charts - advanced options
- Assignment 19: Charts - advanced options - Instructor example
- 100. Report Output using PROC PRINT (6:06)
- Resource - Report output
- 101. Report Output using PROC REPORT- DISPLAY option (7:48)
- Resource - Proc report
- 102. Report Output using PROC REPORT- ORDER & GROUP option (4:58)
- Assignment 20: Report output
- Assignment 20: Report output - Instructor example
- 103. Summary stats - PROC FREQ (8:03)
- Resource - Proc freq
- 104. Summary stats - PROC MEANS (3:04)
- Resource - Proc means
- 105. Summary stats - PROC UNIVARIATE (2:19)
- Resource - Proc univariate
- Assignment 21: Statistical Reported Output
- Assignment 21: Statistical Reported Output - Instructor example
- 106. Output Delivery System (ODS) - Report formats (2:29)
- Resource - ODS Report formats
- 107. ODS with PROC FREQ (4:17)
- Resource - ODS freq
- 108. ODS with PROC MEANS (1:48)
- Resource - ODS means
- 109. ODS with PROC UNIVARIATE (4:04)
- Resource - ODS univariate
- Assignment 22: Output Delivery System
- Assignment 22: Output Delivery System - Instructor example
- QUIZ 16: Visualizing Data
- Assignment 23: "Project Cars" Exercise 3 - Statement (0:31)
- Assignment 23: "Project Cars" Exercise 3 - Instructor Example
- 110. Section Conclusion - Visualizing data (0:52)
Section 6: Optimizing Code
Available in
days
days
after you enroll
- 111. Optimizing Code - Section Overview (0:25)
- 112. Macro Variables - introduction (10:23)
- 113. Macro Variables - code (3:43)
- 114. Application of Macro variables (1:29)
- 115. Application of Macro variables - code (11:05)
- Resource - Macro Vars
- 116. Nested macro variables and Ampersand resolutions (10:56)
- Resource - Nested Macro Vars
- 117. More on Ampersand resolutions using a cool example (9:04)
- Resource - Ampersand resolutions
- Assignment 24: Macro Variables
- Assignment 24: Macro Variables - Instructor example
- 118. SAS Macros - introduction (10:11)
- Resource - Macros
- 119. SAS Macros - Examples (7:11)
- Resource - Macros examples
- 120. Macro Functions (3:30)
- 121. Macro Functions - code (8:41)
- Resource - Functions
- Assignment 25: SAS Macros
- Assignment 25: SAS Macros - Instructor example
- Practice Test 2: Test on Structuring data, visualizing data and macros
- Assignment 26: Guided Exercise - "Project Cars" - Exercise 4 (0:55)
- Assignment 26: Guided Exercise - "Project Cars" - Exercise 4 - Instructor example
- 122. Section Conclusion - Optimizing code (0:30)
Section 7: Practice Exercise | Case Study
Available in
days
days
after you enroll
- 123. Guided Exercise - "Project Heavy-weight" - Introduction to the project and data (2:15)
- Assignment 27: Guided Exercise - "Project Heavy-weight" - Project 1 (0:23)
- Assignment 27: Guided Exercise - "Project Heavy-weight" - Project 1 - Instructor example (13:28)
- Assignment 28: Guided Exercise - "Project Heavy-weight" - Project 2 (0:21)
- Assignment 28: Guided Exercise - "Project Heavy-weight" - Project 2 - Instructor example (8:02)
- Assignment 29: Guided Exercise - "Project Heavy-weight" - Project 3 (0:31)
- Assignment 29: Guided Exercise - "Project Heavy-weight" - Project 3 - Instructor example (4:13)
- Assignment 30: Project Airlines
- Assignment 30: Project Airlines - Instructor example
- 124. And one last thing... Bonus lecture! (1:43)
Did you like this course?
Available in
days
days
after you enroll
Featured Products
You may also be interested in these other courses
Advanced SAS for Clinical Trials
Check out this brief description of another SAS course which may interest you!
Advanced SAS Macros and Proc SQL
You also may want to take a look at this course!