Complete SAS Programming Bootcamp 2019: Go from zero to hero

Course Curriculum

Chapter 1: Setting Up Your SAS Environment and Download the Data!

Lecture 1: Setup your SAS Environment with SAS WPS Analytics

Lecture 2: Setup your SAS Environment with SAS University Edition

Chapter 2: Welcome to the world of SAS!

Lecture 1: What can you do with SAS?

Lecture 2: What is a SAS Program?, How does the syntax work in SAS?

Lecture 3: SAS Libraries (Libname Statement)

Lecture 4: What is a SAS Data Set? Proc Contents and Proc Print

Lecture 5: Types of Variables in SAS

Lecture 6: Filter data using the WHERE statement – Operators (Logic, Comparison, Arithmetic

Lecture 7: Special Operators for the WHERE statement

Lecture 8: What is a SAS Format?

Lecture 9: Dates and Date Formats in SAS

Lecture 10: Creating a user-defined format using Proc Format

Lecture 11: Ordering data and creating reports by Groups using the BY statement

Lecture 12: Improve the aesthetics of a report adding Titles, Footnotes, Labels.

Chapter 3: Data Manipulation I (Learn to use the powerful Data Step!)

Lecture 1: Learn to read a SAS Data Set with the Data Step

Lecture 2: Creating Variables and Filtering Variables with the KEEP & DROP statements

Lecture 3: Difference between filtering with the WHERE and Subsetting IF statements

Lecture 4: Adding Permanent Attributes using the LABEL, FORMAT, and LENGTH statements

Lecture 5: How the Data Step Processing works?

Lecture 6: Using simple functions and learning to get frequencies using PROC FREQ

Lecture 7: Process data conditionally using IF-THEN/ELSE statements

Lecture 8: Execute multiple statements conditionally using DO and END statements

Chapter 4: Summarizing Character and Numeric Data! (Proc Freq, Means, Univariate).

Lecture 1: Summarize Character Data in Frequencies using Proc Freq!

Lecture 2: Create Contingency Tables (2×2 table) with Proc Freq!

Lecture 3: Summarize Numeric Variables with Proc Means (N Mean Median Std Min Max etc..)

Lecture 4: Summarize Numeric Data (Proc Univariate: Quantiles, Central Tendency Measures)

Chapter 5: Importing Data (Excel, CSV, Tab) in different formats/structures

Lecture 1: Using the PUT function to convert Numeric Variable to Character Variable

Lecture 2: Using INPUT function and INFORMATS to convert Character to Numeric variables

Lecture 3: Using PROC IMPORT to import different file formats (csv, xlsx, txt)

Lecture 4: [Advanced] Other techniques to Read Data using Data Step

Lecture 5: [Advanced] COLUMN INPUT technique to read data organized in columns

Lecture 6: [Advanced] FORMATTED INPUT technique to read Nonstandard data organized in colum

Lecture 7: [Advanced] MODIFIED LIST INPUT tecnique to read delimited data (Non/Standar Data

Chapter 6: Data Manipulation II (Controlling Input and Output, Accumulating Totals & more!)

Lecture 1: Writing Observations Explicitly (Output Statement)

Lecture 2: Writing to Multiple SAS Data Sets

Lecture 3: Optimize the processing using SAS Data Set Options (Firstobs=, obs=, Keep=)

Lecture 4: More Data Set Options (Rename = , Where=)

Lecture 5: Create an Accumulating Total Variable (Process data vertically – RETAIN statmnt)

Lecture 6: Accumulating Totals for a Group of Data using the BY Statement and Data Step

Lecture 7: Accumulating Totals for more than One Group using the By statement and Retain

Chapter 7: SAS Functions (Character & Numeric Functions)!

Lecture 1: Character Functions to Extract Text ! (SUBSTR, LENGTH)

Lecture 2: More functions to Extract Text from String! (RIGHT, LEFT, CHAR, PROPCASE)

Lecture 3: More Character Functions (SCAN, INDEX, CATX, TRIM, STRIP)!

Lecture 4: Character Functions to Concatenate Strings (CAT, CATT, CATS)!

Chapter 8: Working with Dates Values (Dates – , Datetime – , Time Values

Lecture 1: Introduction to SAS Dates (Date Values – Datetime Values – Time Values)

Lecture 2: Converting Dates stored in text (Character) to Date Values (Numeric)

Lecture 3: Converting Date Values (Numeric) to text (Character)

Lecture 4: Using the INTCK() function to calculate difference of 2 dates (in months, years)

Lecture 5: Using INTNX() function to increment a date (in years, months, qtrs, days, etc)

Lecture 6: Calculate difference between Dates using the DATDIF() function

Chapter 9: Learning to Combine Data (Concatenating and Merging/Joins)

Lecture 1: Concatenate Data using the Set Statement in the Data Step – Part 1

Lecture 2: Concatenate Data using the Set Statement in the Data Step – Part 2

Lecture 3: Concatenate Data using Proc Append

Lecture 4: Understand how data can be related (One-to-One, One-to-Many, Many-Many)

Lecture 5: Using Merge to get all types of Joins (Left, Right, Inner, Full Join, etc)

Lecture 6: Learn how to merge data in a One-to-One and One-to-Many Scenario

Lecture 7: Warning on Merge Statement in a Many-to-Many scenario, use SQL instead.

Chapter 10: Do Loops – Processing Data Iteratively

Lecture 1: Introduction to Do Loops (Iterative, Do Loop)

Lecture 2: Business Scenario using Iterative, Do-Loops

Lecture 3: Introduction to Infinite Loops (Do While and Do Until)

Lecture 4: Business Scenario using Do While/Do Until

Lecture 5: Solving a Business Scenario Using Iterative, Do Loops and Do While/Until

Lecture 6: Learn to use Nested Do Loops to solve real problems!

Chapter 11: Working with Arrays and Learning to Transpose Data

Lecture 1: Introduction to Arrays

Lecture 2: Ways to reference Variable Lists in Arrays

Lecture 3: Create and Compare different variables using Arrays

Lecture 4: Using Arrays as a Look Up Table to make comparisons

Lecture 5: Exercise 1 – Using Arrays to look for the Max Sale using INDEX and VNAME functio

Lecture 6: Exercise 2 – Using Arrays as a lookup Table to find Antibiotics in prescriptions

Lecture 7: Using Arrays to Reestructure a Dataset (Transpose and Stack Columns)

Lecture 8: Intro to Proc Transpose (Easiest way to Transpose/Stack Columns in SAS)

Chapter 12: Pivot Tables in SAS using Proc Tabulate!

Lecture 1: Introduction to Proc Tabulate

Lecture 2: Creating the Structure of the Table: One- ,Two- , Three- Dimensional Tables

Lecture 3: Creating the Structure of the Table: Concatenating and Crossing Variables

Lecture 4: Adding Overall Summarizations using the Keyword ALL (Totals, SubTotals)

Lecture 5: Adding Statistics to the Analysis Variables (Median, Quartiles, Percentiles)

Lecture 6: Adding different Percentages (Column-, Row-, Report- Percentages)

Lecture 7: Specify a denominator to calculate Percentages using keyword PCTN

Lecture 8: Improve the Aesthetics changing Labels, KeyLabels, Formats

Lecture 9: Adding Formats to Percentages and Customize missing Values

Lecture 10: Creating a Professional Report with Proc Tabulate in 20 mins!

Chapter 13: Creating Reports with Proc Report!

Lecture 1: Introduction to Proc Report – Variable Usages

Lecture 2: Learn to Create Detail Report Using the Display and Order Usage

Lecture 3: Learn to Create Summary Reports using the GROUP Usage and Add Statistics

Lecture 4: Learn to Transpose a Variable with the Across Usage

Lecture 5: Learn how to create a variable in a Report using the Computed Usage