This course includes:
- 12.5 hours on-demand video
- downloadable resources
- Interim review quizzes
- Full lifetime access
- Access on mobile devices
-
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.
Base course
Learn the course content at your own pace. If you have questions or curiosities, you may want to pay just a little more and have the possibility to interact directly with the expert trainer.
Have a look at the course with the "Expert Support Available" tag.
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 watching all videos and complete the practice quizzes, 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.
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
- 18. Bringing data into SAS using DELIMITER option (3:19)
- Resource - Delimiter
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Practice test 1: Preparing data
- 60. Guided Exercise - "Project Cars" - Introduction (1:29)
- 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)
- 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
- 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
- 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
- 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
- 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
- QUIZ 15: Structuring Data
- 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
- 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)
- 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
- 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
- QUIZ 16: Visualizing Data
- 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
- 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
- Practice Test 2: Test on Structuring data, visualizing data and macros
- 122. Section Conclusion - Optimizing code (0:30)
Section 7: Practice Exercise | Case Study
Available in
days
days
after you enroll
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!