The Simplest Guide™ to SAS Programming*SAS Base*SAS Advanced
4.5 (519 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,170 students enrolled

The Simplest Guide™ to SAS Programming*SAS Base*SAS Advanced

SAS certification exam prep guide| Learn Base SAS, Advance SAS and SAS Analytics in a simple, visual and engaging style
Bestseller
4.5 (519 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,170 students enrolled
Last updated 3/2020
English
English [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 11.5 hours on-demand video
  • 71 downloadable resources
  • 2 Practice Tests
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn SAS in the most effective way through simple, visual and engaging lectures
  • 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 Heavy-weight" exercise at the end
  • 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 download and work in SAS University Edition
  • Since this course is highly visual in nature, this is not suitable for audio listening only
Description

A  comprehensive, simple and visual guide to SAS Programming, this course is simplified into the 4 main areas : Data Preparation, Data Structuring, Data Visualization and Optimizing Code

  • This course is for absolute beginners and 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 two SAS certification exams: SAS Base and SAS Advanced

  • This course uses the SAS University Edition that is Free to download and install on a PC or Mac

COURSE SECTIONS

  1. 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

  2. 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)

  3. DATA VISUALIZATION will propel you further into the world of analytics and obtaining insightful inferences from what is inside your data

  4. 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 the course, you will try out most concepts discussed in this course through a coding exercise that will take you through the 4 sections.

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.


*****ABOUT THE COURSE STYLE******

Online learning need not be like “Cat vs Laser Pointer” videos for students...

Let me ask you a question. Why do so many instructors who teach online think their students are like their pet cats? Amazed why I think of it this way. Just go look at any course videos on Udemy or Youtube, and you will see the way most instructors teach their courses is to point a colored laser dot on their course video, and demand students to follow through the entire course material. Still worse, some instructors use their dumb mouse pointers for this purpose !

Why do students who are just building excitement in learning a new topic have to put up with these uninteresting lectures. The worst way an instructor can teach a subject is to bombarded his or her students with a series of text-heavy slides with tons of bullet points. As if that was not boring enough to kill student’s enthusiasm, they use the mesmerizing laser pointer and move like crazy all over the screen.

Welcome to the new way of teaching !

We are visual creatures because most of our brain is wired for visual sensory processing. The quickest way to learn, remember and more importantly understand anything new is to not read it from a set of slides with a background narration from an instructor, but to visually see with your eyes what is being taught in the form of real-world objects, associate them to the topic being discussed, and then allow our brains to form those hard-to-forget indelible connections in our minds. If every instructor taught this way; with a little bit of practice and effort, most of you can not only comprehend the subject, but also master it in the quickest possible way. That is why you will almost never find me using bullet points in my course lectures, and never will you find me bringing up the dreadful laser pointer, EVER !

By using the latest in touch-screen technology and a lot of on-screen sketches, I make the course lectures come to life ! I do this to have an impact on YOU,  by LEADING your eyes to what you should focus on a slide, and letting your MIND follow-through, and to ultimately make you UNDERSTAND the topic. See it for yourself !


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
Course content
Expand all 90 lectures 11:39:12
+ Why learn SAS | Course Overview
1 lecture 00:44

Before we even get into the first lecture, we will get convinced why should you learn SAS as a tool to handle data, and in which of the industries is it going to be helpful to you. This course is nothing different from other courses in terms of content and topics covered, but what sets it apart is it is delivered in a compelling and captivating way, not because of any eloquent narration, graphical superiority or mastery in the subject, but primarily because of a meaningful flow and easy to follow through even during discussing complex topics.

The worst way an instructor can teach on a subject is to bombarded his or her students with an overload of  textual slides consisting of tons of bullet points. We are visual creatures because most of our brain is wired for visual sensory processing. The quickest way to learn, remember and more importantly understand anything new is to not read it from a set of slides with a background narration from an instructor, but to see visually see with your eyes what is being taught in the form of real-world objects, associate them to the topic being discussed, and then allow our brains to form those indelible connections in our minds that are hard to forget. If every instructor taught this way; with a little bit of practice and effort from a student like you, you can not only comprehend the subject, but also master it in the quickest possible way. That is the promise of this course that makes it different from other courses on the topic.

Preview 00:44
+ Getting started with SAS Programming
4 lectures 19:48

You will see why is SAS so easy to learn in this lecture. I compare how we generate a simple table programmed in C/C++ programming language, and contrast it with the simple code done in SAS programming. You will really see how easy it is !

Preview 02:45

Follow through this step-by-step guide for the installation of SAS University Edition from start to end. Its easy and done in 3 steps. Be a little patient when downloading the large files since that might take some time depending on your internet bandwidth.

*****************************DEBUGGING THE ISSUE WITH VIRTUALIZATION ********************

Some of  you may encounter an issue after installing the VirutalBox. Since you will be using SAS University Edition, this is somewhat different from installing the licensed copy of SAS (that comes at a hefty price tag !). The way this works is, SAS university edition runs on a computer somewhere. All you do is hook up to that computer that runs this edition of SAS through VirtualBox application (this is like loading a movie disc in a DVD Player at your friends house, and watching the movie on your TV through a connection into your house). This is called Virtualization.

Some computers by default have the "virtualization" disabled. This can be fixed quickly by enabling virtualization in the BIOS setup (Don't worry if you don't know BIOS). Just follow the instructions from this video from SAS Support https://www.youtube.com/watch?v=o7T75Co_dQg


Preview 10:21

After the one-time install, this lecture shows how to login every time you want to start a SAS session. You will need an internet connection every time you want to connect to SAS university edition.

Logging-in to a SAS Session after installation
00:42

Get used to the SAS user interface (GUI) and various windows in the SAS session.

Preview 06:00

Basic fundamental concepts in SAS

SAS user interface/ windowing environment
3 questions
+ Preparing Data
36 lectures 04:46:40

The section on preparing data will enable you to import data from common sources like the ubiquitous spreadsheets; create your own datasets within SAS, and work with SAS-supplied datasets. It will enable you to  modify the data to make it  more meaningful, and lastly perform some basic functions on variables. By the end of this section, you will have fully understood how is data handled in SAS, how it is stored in libraries and datasets, and modified using functions.

Preparing Data - Section Overview
00:05

Introduction to SAS dataset structure, variable and observations that make up a dataset, and the different types of variables

SAS Dataset, Variables and Observations
08:44

A SAS library, just like a library containing a lot of books, is a place to store lots of data together. Get introduced to the two different types of libraries, and their purposes.

SAS Libraries
04:50

Learn the 3 rules of naming for libraries- very simple and clear rules you gotta remember all along the way !

Library Naming Conventions
04:48

Similar to rules of naming of libraries, there are rules of naming for datasets

Dataset Naming Conventions
04:05

Get used to the language, grammar and syntax of SAS - its pretty much 90% english, with some machine-language characters like the semi-colon along the way

SAS Program Syntax
06:57

Know the two important modules in SAS code - the Data Step and Proc Step, and when they are used and for what purposes

Preview 02:35

Just like finding books in a library through a catalog, data can be called upon from somewhere inside a library in two ways. Learn the single-level and two-level referencing.

Referencing data in SAS
04:47

3 methods of bringing in data into SAS is discussed here

1. From within SAS that came with it pre-installed

2. From within the coding using cards/ datalines statement (you create whatever you want to become a dataset- this is cool stuff !)

3. From outside Excel sheets using an import wizard and without writing a single line of code !

Bringing data into SAS
16:01
Bringing data into SAS using the LIBNAME statement
05:21
Bringing data into SAS using the FILENAME statement
05:09
Bringing data into SAS using DSD option
07:36
Bringing data into SAS using column input
04:02
Bringing data into SAS using column pointer @ symbol
01:53
Bringing data into SAS using the line pointer # symbol
07:10
Bringing data into SAS using line pointer slash symbol
02:24
Bringing data into SAS using the trailing @ symbol
03:09
Bringing data into SAS using the trailing double @ symbol
02:26
Bringing in data from within SAS
Get "cars" data into your SAS Session
3 questions

Learn how to create new variables, building upon the dataset how you wish it to be

Creating new variables
12:31
Keeping, Dropping and Renaming Variables in a Dataset
02:59
Using the following formula to calculate the BMI (Body Mass Index), derive the new variable called BMI in the same dataset CLASS. BMI= Weight (in kgs)/ Square of the Height (in meters) Hint: Square of the height = Height X Height
Create the BMI (Body Mass Index) new variable from Weight and Height variables
1 question

Learn creating new variables conditionally, with cool funny illustrations (stick figures) to explain the concept. Uses the if-else conditional logic.

If-else conditional statements
15:51

Learn how to filter observations you dont want to be part of your dataset, using where statement. See how it works in a proc step vs data step.

Filtering data
11:21
Using the concept of Filtering, find out the most expensive cars in the CARS dataset
Finding the most expensive cars
1 question

Learn how SAS treats dates, and why are they represented as integer numbers. Learn what happened on 01 Jan 1960 !

SAS Dates
06:48

You will learn how to modify a variable to take on new values - like changing casing of words in observations, and combining two variables together.

SAS Functions - Upcase, Lowcase, Propcase, Length, Cat
22:12
SAS Functions - Substr, Trim, Left, Strip, Compress, Compbl
17:16

Questions on the section 1: Preparing data

Preparing Data
5 questions
SAS Formats - Introduction
03:37
Format Statement
06:35
Format Naming Conventions
10:26
Format using the PUT function
09:44
SAS Informats
13:58
Custom formats using Proc Format
16:35
Program Data Vector (PDV)
05:43
Implicit Output
14:34
Explicit Output
17:01
Do Loops
04:08

This is a test on all the concepts related to preparing data

Preparing data
11 questions
+ Structuring Data
26 lectures 03:54:48

This is the section on Structuring Data that will make you leap into transforming data to a new level by teaching you how to stack data together, merging multiple datasets together, turning them upside-down (by sorting), and even side-ways -- why would you do that ! (by transposing)

Structuring Data - Section Overview
00:09

Learn the simple data SET statement for appending/ stacking data together

Preview 05:35
Stacking Data using PROC APPEND
14:38
Interleaving of data
09:02

Learn about a very powerful procecure called Proc Sort in SAS. You will learn to rearrange data as you wish based on certain criteria.

Sorting Data using PROC SORT
14:59
Removing duplicates -NODUP Option
11:09
Removing duplicates -NODUPKEY Option
10:35

Done in complex ways in other programming languages, merging of data is done rather simply in SAS. Learn about Data merge method and its use. Remember --> there is no Proc Merge in SAS !

Simple merging of data
08:42
Merging data using Joins - Introduction
07:41
Merging data using Inner Join
16:14
Merging data using Full Join
07:24
Merging data using Left Join
06:15
Merging data using Right Join
03:41
Merging data using "far" joins
06:27
PROC SQL - copying data
13:15
PROC SQL - filtering data
06:54
PROC SQL - sorting data
08:27
PROC SQL - removing duplicates
05:26
Proc SQL - Inner Join
14:18
Proc SQL - Full Join
07:42
Proc SQL - Left and Right Joins
06:52
Transposing data - ID Statement
13:15
Transposing data - BY statement
14:27
Retain Statement - Introduction
07:23
Retain Statement - how to use
06:18
Retain Statement - Example
08:00

Questions on Section 2: Structuring data

Structuring data
3 questions
+ Visualizing Data
16 lectures 01:28:03

This section on Data Visualization will propel you further into the world of analytics and obtaining insightful inferences to see what is inside your data. You will be able to generate beautiful charts, plots and other visual representation of data.

Visualizing Data - Section Overview
00:06

Learn about Proc Chart - a simple and powerful proc in SAS to visualize what is within your data and see it in a horizontal, vertical and pie charts

Charts
11:19
Vertical bar chart - DISCRETE option
09:43
Horizontal bar chart - DISCRETE option
01:34
Vertical bar chart - groups and subgroups
11:28
Horizontal bar chart - groups and subgroups
03:13

Obtain insights into your data through the scatter plot for 2 variables. This lecture will teach you about Proc Plot

Plots
05:43

Probably the least appreciated proc in SAS is the Proc Print. It is simply to show data in report output that can then be used for printing. The proc itself does not send your data to a printer !

Preview 06:06
Report Output using PROC REPORT
12:48
Summary statistics - PROC FREQ
08:03
Summary statistics - PROC MEANS
03:04
Summary statistics - PROC UNIVARIATE
02:19
Output Delivery System (ODS) - Report Formats
02:29
ODS with Proc Freq
04:16
ODS with Proc Means
01:48
ODS with Proc Univariate
04:04

Questions on Sec 3: Visualization of data

Visualizing Data
3 questions
+ Optimizing Code
7 lectures 01:09:09
Optimizing Code - Section Overview
00:06
Macro Variables - introduction
14:07
Application of Macro variables
12:35
Nested macro variables and ampersand resolutions
10:56
More on Ampersand resolutions using a cool example
09:04
SAS Macros - introduction
10:10
Macro Functions
12:11

This is a test on the topics learnt under the sections Structuring data, visualizing data and macros

Test on Structuring data, visualizing data and macros
10 questions
+ Practice Exercise | Case Study
0 lectures 00:00
Analyze the data of 13 students by generating a pie chart of their health status (healthy weight, overweight or obese)
Project Heavy-weight
1 question