Complete SAS Programming Bootcamp 2019: Go from zero to hero

Learn to program in the SAS Language, also known as SAS Base or Base SAS. SAS Programming is awesome for Data Science!

4.10 (132 reviews)
Udemy
platform
English
language
Web Development
category
7,295
students
9 hours
content
Feb 2019
last update
$39.99
regular price

What you will learn

You will learn the SAS language from scratch and we will get you to an expert level! You will learn from the basics: Importing Data, SAS Variables, SAS Dates, Formats, Procedures and much more!

We will teach how to use the Data Step to do all types of data manipulations, filtering, transforming variables, do complex calculations.

Learn how to combine data, transpose , use do loops, arrays, summarize data with pivot tables, creating professional reports.

Learn how to use SAS Functions to manipulate Character, Numeric, Date Variables.

Description

In this course you will learn to program in the SAS Language to do data analysis. This language is really easy to learn since you don't need to write too much code to get great results!

This course is broken down in 3 parts: 1. Beginner, 2. Intermediate, 3. Advanced. So anyone interested in learning how to program in SAS, from people with nothing or some experience, can enroll in this course.

The most important requirement to enroll is to be committed to learn it and be willing to invest some hours. I promise you once you are done with this course, you will feel very comfortable and loving it when programming in this wonderful language!

Content

Setting Up Your SAS Environment and Download the Data!

Setup your SAS Environment with SAS WPS Analytics
Setup your SAS Environment with SAS University Edition

Welcome to the world of SAS!

What can you do with SAS?
What is a SAS Program?, How does the syntax work in SAS?
SAS Libraries (Libname Statement)
What is a SAS Data Set? Proc Contents and Proc Print
Types of Variables in SAS
Filter data using the WHERE statement - Operators (Logic, Comparison, Arithmetic
Special Operators for the WHERE statement
What is a SAS Format?
Dates and Date Formats in SAS
Creating a user-defined format using Proc Format
Ordering data and creating reports by Groups using the BY statement
Improve the aesthetics of a report adding Titles, Footnotes, Labels.

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

Learn to read a SAS Data Set with the Data Step
Creating Variables and Filtering Variables with the KEEP & DROP statements
Difference between filtering with the WHERE and Subsetting IF statements
Adding Permanent Attributes using the LABEL, FORMAT, and LENGTH statements
How the Data Step Processing works?
Using simple functions and learning to get frequencies using PROC FREQ
Process data conditionally using IF-THEN/ELSE statements
Execute multiple statements conditionally using DO and END statements

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

Summarize Character Data in Frequencies using Proc Freq!
Create Contingency Tables (2x2 table) with Proc Freq!
Summarize Numeric Variables with Proc Means (N Mean Median Std Min Max etc..)
Summarize Numeric Data (Proc Univariate: Quantiles, Central Tendency Measures)

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

Using the PUT function to convert Numeric Variable to Character Variable
Using INPUT function and INFORMATS to convert Character to Numeric variables
Using PROC IMPORT to import different file formats (csv, xlsx, txt)
[Advanced] Other techniques to Read Data using Data Step
[Advanced] COLUMN INPUT technique to read data organized in columns
[Advanced] FORMATTED INPUT technique to read Nonstandard data organized in colum
[Advanced] MODIFIED LIST INPUT tecnique to read delimited data (Non/Standar Data

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

Writing Observations Explicitly (Output Statement)
Writing to Multiple SAS Data Sets
Optimize the processing using SAS Data Set Options (Firstobs=, obs=, Keep=)
More Data Set Options (Rename = , Where=)
Create an Accumulating Total Variable (Process data vertically - RETAIN statmnt)
Accumulating Totals for a Group of Data using the BY Statement and Data Step
Accumulating Totals for more than One Group using the By statement and Retain

SAS Functions (Character & Numeric Functions)!

Character Functions to Extract Text ! (SUBSTR, LENGTH)
More functions to Extract Text from String! (RIGHT, LEFT, CHAR, PROPCASE)
More Character Functions (SCAN, INDEX, CATX, TRIM, STRIP)!
Character Functions to Concatenate Strings (CAT, CATT, CATS)!

Working with Dates Values (Dates - , Datetime - , Time Values

Introduction to SAS Dates (Date Values - Datetime Values - Time Values)
Converting Dates stored in text (Character) to Date Values (Numeric)
Converting Date Values (Numeric) to text (Character)
Using the INTCK() function to calculate difference of 2 dates (in months, years)
Using INTNX() function to increment a date (in years, months, qtrs, days, etc)
Calculate difference between Dates using the DATDIF() function

Learning to Combine Data (Concatenating and Merging/Joins)

Concatenate Data using the Set Statement in the Data Step - Part 1
Concatenate Data using the Set Statement in the Data Step - Part 2
Concatenate Data using Proc Append
Understand how data can be related (One-to-One, One-to-Many, Many-Many)
Using Merge to get all types of Joins (Left, Right, Inner, Full Join, etc)
Learn how to merge data in a One-to-One and One-to-Many Scenario
Warning on Merge Statement in a Many-to-Many scenario, use SQL instead.

Do Loops - Processing Data Iteratively

Introduction to Do Loops (Iterative, Do Loop)
Business Scenario using Iterative, Do-Loops
Introduction to Infinite Loops (Do While and Do Until)
Business Scenario using Do While/Do Until
Solving a Business Scenario Using Iterative, Do Loops and Do While/Until
Learn to use Nested Do Loops to solve real problems!

Working with Arrays and Learning to Transpose Data

Introduction to Arrays
Ways to reference Variable Lists in Arrays
Create and Compare different variables using Arrays
Using Arrays as a Look Up Table to make comparisons
Exercise 1 - Using Arrays to look for the Max Sale using INDEX and VNAME functio
Exercise 2 - Using Arrays as a lookup Table to find Antibiotics in prescriptions
Using Arrays to Reestructure a Dataset (Transpose and Stack Columns)
Intro to Proc Transpose (Easiest way to Transpose/Stack Columns in SAS)

Pivot Tables in SAS using Proc Tabulate!

Introduction to Proc Tabulate
Creating the Structure of the Table: One- ,Two- , Three- Dimensional Tables
Creating the Structure of the Table: Concatenating and Crossing Variables
Adding Overall Summarizations using the Keyword ALL (Totals, SubTotals)
Adding Statistics to the Analysis Variables (Median, Quartiles, Percentiles)
Adding different Percentages (Column-, Row-, Report- Percentages)
Specify a denominator to calculate Percentages using keyword PCTN
Improve the Aesthetics changing Labels, KeyLabels, Formats
Adding Formats to Percentages and Customize missing Values
Creating a Professional Report with Proc Tabulate in 20 mins!

Creating Reports with Proc Report!

Introduction to Proc Report - Variable Usages
Learn to Create Detail Report Using the Display and Order Usage
Learn to Create Summary Reports using the GROUP Usage and Add Statistics
Learn to Transpose a Variable with the Across Usage
Learn how to create a variable in a Report using the Computed Usage

Screenshots

Complete SAS Programming Bootcamp 2019: Go from zero to hero - Screenshot_01Complete SAS Programming Bootcamp 2019: Go from zero to hero - Screenshot_02Complete SAS Programming Bootcamp 2019: Go from zero to hero - Screenshot_03Complete SAS Programming Bootcamp 2019: Go from zero to hero - Screenshot_04

Reviews

Cheralita
May 1, 2022
I have posted what issues I am having but no one is responding. The Instructor is where????? Does he check back to see what is going on? I paid for this "Course"... and cannot get into the Environments because what I need is NOWHERE. Thanks a LOT!
João
June 16, 2020
From Brasil, i will leave your course to my profissional life. I work at Itaú and the expertise i've winned seeing your classes made me be recognized by my teammates and now i'm working with a lot of projects. Thank you so much!
Martin
November 14, 2019
The content was ok - although didnt cover proc sql which everyone in my office uses. Worth mentioning at least Also Dario is very fast, and his english is not great. I think dario rushes the course and doesnt give you time to digest concepts at a greater level of understanding
Hamidou
October 18, 2019
Yes, it is a very good match. But sometimes we got lost, since the instructor skips some steps and does not about where he tasks the data, but overall it is Wonderful.
Kelly
February 19, 2019
This is an amazing course for beginners!, you will find almost everything you need to start coding with SAS. The course is very well designed, practical and valuable for anyone who wants to learn SAS. Definitely shows the amount of hard work put in by the instructor. Thank you.
Romit
January 23, 2019
The instructor is fantastic and explains very well. If he includes more exercises in his coursework, it would be very engaging and people will have hands-on solving those exercises.

Charts

Price

Complete SAS Programming Bootcamp 2019: Go from zero to hero - Price chart

Rating

Complete SAS Programming Bootcamp 2019: Go from zero to hero - Ratings chart

Enrollment distribution

Complete SAS Programming Bootcamp 2019: Go from zero to hero - Distribution chart

Related Topics

2135564
udemy ID
1/7/2019
course created date
5/13/2019
course indexed date
Bot
course submited by