image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

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, 100+ videos, 65 Quiz questions and 2 Practice Tests, followed by 2 practical and hands-on guided exercises and projects
Download the SAS Programming Resource Guide eBook (100+ pages) as accompanying slides and notes. Use it for quick reference to the lectures, make your own notes on top of this, or use them as presentation slides wherever you want !
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.
COURSE SECTIONS
DATA PREPARATION
will teach you how to import data from multiple sources, create new variables, write SAS functions, and understand what goes on behind the scenes in SAS datasets
DATA STRUCTURING
will make you leap into transforming data to a new level by merging and joining multiple datasets together, or turning them upside-down (sorting), and side-ways (transposing)
DATA VISUALIZATION
will propel you further into the world of analytics and obtaining insightful inferences from what is inside your data
OPTIMIZING CODE
will  take into the world of macro programming that teaches you how to write your code professionally and elegantly
At the end of each section, you will try out most concepts discussed in that section through coding exercises and guided assignments. Don't worry if you make mistakes in the assignments, these are guided assignments where I hand-hold you showing all the steps to get them correctly done. At the end of the course, there are 3 practical
Capstone projects
that are based on concepts from all sections of the course.
If you wish to further hone your SAS programming skills learnt in this course and
apply it on a practical real-life example
,
I recommend you take my other course on Clinical SAS Programming
. If the clinical portion doesn’t interest you, can you skip straight to the hands-on programming lectures (Section 3 onward) where you will begin working with a sample (clinical) data in an Excel sheet, which you will import into SAS, derive all necessary variables as in the mock shell specifications through various procs and functions, and finally generate a clinical study report. All this will be done using guided SAS Programming steps with detailed explanations at every step of programming.
Here’s what makes this course exceptional:

Accessible Learning:
You will gain hands-on experience with
SAS OnDemand
, which is
free
and cloud-based, eliminating the need for costly software licenses or installations on your computer. All you need is a working computer, a web browser, and an internet connection.

Comprehensive Skill Development
: You'll learn how to bring in data from multiple sources, including text files and pre-existing SAS datasets. You will also learn the techniques to clean and prepare data by handling delimiters and special characters. You'll master essential data manipulation techniques such as creating new variables, filtering data using where statements, and modifying data.

Advanced Data Techniques
: You will delve into advanced techniques such as using conditional if-else statements to create new variables conditionally, creating custom formats using proc format and also creating formatted reports using proc report. This course will also teach you how to merge data from different sources using various types of joins including a full join.

Powerful Data Visualization
: You'll learn how to represent data in actionable formats through various visualizations using proc chart for both horizontal and vertical bar charts. You'll also be able to create summary statistics, which will provide greater insights into the data.

Efficient Code Optimization
: You'll discover how to optimize your SAS code using powerful tools like
SAS macros
, which will allow you to write less code while accomplishing complex tasks. You will be able to apply macro functions to perform operations on macro variables.

Real-World Applications
: You will solidify your understanding by working on real-world data-driven projects, such as importing and analyzing car data from different regions, and working on student health data. Through these projects, you'll learn how to reuse code to generate multiple reports.

Career Advancement
: By the end of this course, you'll be equipped with the skills to confidently navigate data, perform complex analyses, and create visualizations, all of which can significantly boost your career prospects in the data-driven industries. This course will also prepare you for the real-world challenges of working with complex datasets.
This course is not just about learning SAS; it’s about transforming the way you approach data. Enroll now to begin your journey toward becoming a proficient SAS programmer, capable of handling real-world data challenges and stepping into a variety of career opportunities.
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 OnDemand 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

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

Explained through DYNAMIC CODING done live during lectures for effective student learning

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

Apply all topics through numerous assignments 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

Join a thriving community of 10,000+ students to learn, grow and thrive in a competitive world

Download the accompanying Resource Guide containing course slides - make notes, present anywhere, make it your own !

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Why learn SAS
1
Course Introduction and Overview
1.1-Course Overview;1.2-Download the SAS Programming Resource Guide
1
2-Getting started with SAS Programming
2.1-Why is SAS so easy to learn;2.2-SAS Studio through SAS OnDemand - Registration;2.3-Logging-in to a SAS Session;2.4-SAS User Interface;2.5-SAS user interface/ windowing environment
1
3-Preparing Data
3.1-Preparing Data - Section Overview;3.2-SAS Dataset, Variables and Observations;3.3-SAS Libraries;3.4-Library Naming Conventions;3.5-Dataset Naming Conventions;3.6-SAS Program Syntax;3.7-SAS Data Step and Proc Step;3.8-Referencing data in SAS;3.9-SAS Elements;3.10-Bringing data into SAS;3.11-Bringing data into SAS using the Import Wizard;3.12-Bringing data into SAS using the LIBNAME statement;3.13-Bringing data into SAS using the FILENAME statement;3.14-Bringing data into SAS;3.15-Bringing data into SAS;3.16-Bringing data into SAS using DELIMITER option;3.17-Bringing data into SAS using Delimiter option;3.18-Bringing data into SAS using DSD option;3.19-Bringing data into SAS using column input;3.20-Bringing data into SAS using column pointer @ symbol;3.21-Bringing data into SAS using the line pointer # symbol;3.22-Bringing data into SAS using line pointer slash symbol;3.23-Bringing data into SAS using the trailing @ symbol;3.24-Bringing data into SAS using the trailing double @ symbol;3.25-Bringing data into SAS - Advanced Methods;3.26-Bringing data into SAS using advanced options;3.27-Bringing data into SAS using Proc Import for XLS (MS Excel) Files;3.28-Bringing data into SAS using Proc Import for TXT Files;3.29-Bringing data into SAS using Import procedure;3.30-Get "berries" data into your SAS session;3.31-Creating new variables;3.32-Creating new variables - code;3.33-Keeping, Dropping and Renaming Variables in a Dataset;3.34-If-else conditional statements - deriving BMI variable;3.35-If-else conditional statements - deriving STATUS variable;3.36-Filtering data;3.37-New variables, conditional logic;3.38-Conditional logic and filtering data;3.39-Finding the most expensive cars;3.40-SAS Dates;3.41-SAS Character Functions - Upcase function;3.42-SAS Character Functions - Lowcase, Propcase, Len, Cat functions;3.43-SAS Character Functions - Substr function;3.44-SAS Character Functions -Trim, Left, Strip, Compress, Compbl functions;3.45-SAS Character Functions - Scan function;3.46-SAS Character Functions - Index functions;3.47-SAS Numeric Functions - Sum function;3.48-Null Dataset;3.49-SAS Numeric Functions - Abs function;3.50-SAS Numeric Functions - Ceiling, Floor and Integer Functions;3.51-SAS Numeric Functions - Minimum and Maximum functions;3.52-SAS Dates And SAS Functions;3.53-Applying SAS Functions;3.54-SAS Formats - Introduction;3.55-Format Statement;3.56-Format Naming Conventions;3.57-Format using the PUT function;3.58-SAS Informats;3.59-SAS Informats - code;3.60-Custom formats using Proc Format;3.61-Custom formats using Proc Format - code;3.62-Formats in SAS;3.63-Applying SAS formats;3.64-Program Data Vector (PDV);3.65-Implicit Output- Descriptor portion;3.66-Implicit Output - var and data portion;3.67-Explicit Output;3.68-Explicit Output - code;3.69-Do Loops;3.70-Behind the scenes;3.71-Using explicit output statement;3.72-Preparing data;3.73-Guided Exercise - "Project Cars" - Introduction;3.74-Guided Exercise - "Project Cars" - Exercise 1;3.75-Secret SAS Proc revealed !;3.76-Preparing data - Section Conclusion
1
4-Structuring Data
4.1-Structuring Data - Section Overview;4.2-Stacking Data using a Data Step;4.3-Stacking Data using PROC APPEND;4.4-Stacking Data using PROC APPEND- code;4.5-Interleaving of data;4.6-Stacking of data;4.7-Sorting Data using PROC SORT;4.8-Sorting Data using PROC SORT - multi-level sorting;4.9-Interleaving Data;4.10-Removing duplicates -NODUP Option;4.11-Removing duplicates -NODUPKEY Option;4.12-Sorting data;4.13-Removing Duplicates;4.14-Simple merging of data;4.15-Merging data using Joins - Introduction;4.16-Merging data using Inner Join;4.17-Merging data using Inner join - code;4.18-Merging data using Full Join;4.19-Merging data using Left Join;4.20-Merging data using Right Join;4.21-Merging data using "far" joins;4.22-Merging data;4.23-Merging of data;4.24-PROC SQL - copying data;4.25-Proc SQL - copying data - code;4.26-PROC SQL - filtering data;4.27-PROC SQL - sorting data;4.28-PROC SQL - removing duplicates;4.29-Proc SQL;4.30-Proc SQL;4.31-Transposing data - ID Statement;4.32-Transposing data - ID Statement - code;4.33-Transposing data - BY statement;4.34-Transposing data - BY statement - code;4.35-Transposing Data;4.36-Transposing of data;4.37-Retain Statement - Introduction;4.38-Retain Statement - how to use;4.39-Retain Statement - Example;4.40-Retain statement;4.41-Structuring data;4.42-Guided Exercise - "Project Cars" - Exercise 2;4.43-Structuring data - Section Conclusion
1
5-Visualizing Data
5.1-Visualizing Data - Section Overview;5.2-Charts - Introduction - Vertical Bar Chart;5.3-Charts - Horizontal Bar and Pie Charts;5.4-Vertical bar chart - DISCRETE option;5.5-Horizontal bar chart - DISCRETE option;5.6-Vertical bar chart - groups and subgroups;5.7-Horizontal bar chart - groups and subgroups;5.8-Plots;5.9-Charts - advanced options;5.10-Report Output using PROC PRINT;5.11-Report Output using PROC REPORT - DISPLAY option;5.12-Report Output using PROC REPORT - ORDER & GROUP option;5.13-Report output;5.14-Summary statistics - PROC FREQ;5.15-Summary statistics - PROC MEANS;5.16-Summary statistics - PROC UNIVARIATE;5.17-Statistical Report Output;5.18-Output Delivery System (ODS) - Report Formats;5.19-ODS with Proc Freq;5.20-ODS with Proc Means;5.21-ODS with Proc Univariate;5.22-Output Delivery System;5.23-Visualizing Data;5.24-Guided Exercise - "Project Cars" - Exercise 3;5.25-Visualizing data - Section Conclusion
1
6-Optimizing Code
6.1-Optimizing Code - Section Overview;6.2-Macro Variables - introduction;6.3-Macro Variables - introduction - code;6.4-Application of Macro variables;6.5-Application of Macro variables - code;6.6-Nested macro variables and ampersand resolutions;6.7-More on Ampersand resolutions using a cool example;6.8-Macro Variables;6.9-SAS Macros - introduction;6.10-SAS Macros - Examples;6.11-Macro Functions;6.12-Macro Functions - code;6.13-SAS Macros;6.14-Test on Structuring data, visualizing data and macros;6.15-Guided Exercise - "Project Cars" - Exercise 4;6.16-Optimizing code - Section Conclusion
1
7-Capstone Project
7.1-Guided Exercise - "Project Heavy-weight" - Introduction to the project and data;7.2-Guided Exercise - "Project Heavy-weight" - Project 1;7.3-Guided Exercise - "Project Heavy-weight" - Project 2;7.4-Guided Exercise - "Project Heavy-weight" - Project 3;7.5-Project Airlines;7.6-And one last thing... (bonus !!!)
0