Name: Complete SAS Programming Bootcamp 2019: Go from zero to hero
Rating: 4.3 (108 reviews)

What you'll 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.

13 sections • 86 lectures • 8h 57m total length

Setup your SAS Environment with SAS WPS Analytics
Preview04:14
Preview04:56

Preview06:19
What is a SAS Program?, How does the syntax work in SAS?
04:57
SAS Libraries (Libname Statement)
03:55
Preview07:54
Types of Variables in SAS
04:28
Filter data using the WHERE statement - Operators (Logic, Comparison, Arithmetic
06:13
Special Operators for the WHERE statement
03:51
Preview06:33
Dates and Date Formats in SAS
06:46
Creating a user-defined format using Proc Format
05:15
Ordering data and creating reports by Groups using the BY statement
04:09
Improve the aesthetics of a report adding Titles, Footnotes, Labels.
05:23

Learn to read a SAS Data Set with the Data Step
06:58
Creating Variables and Filtering Variables with the KEEP & DROP statements
04:53
Preview03:18
Adding Permanent Attributes using the LABEL, FORMAT, and LENGTH statements
06:54
How the Data Step Processing works?
07:24
Preview05:13
Process data conditionally using IF-THEN/ELSE statements
06:26
Execute multiple statements conditionally using DO and END statements
02:16

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

Preview06:58
Writing to Multiple SAS Data Sets
07:00
Optimize the processing using SAS Data Set Options (Firstobs=, obs=, Keep=)
07:20
More Data Set Options (Rename = , Where=)
05:19
Create an Accumulating Total Variable (Process data vertically - RETAIN statmnt)
08:02
Accumulating Totals for a Group of Data using the BY Statement and Data Step
07:13
Accumulating Totals for more than One Group using the By statement and Retain
08:11

Introduction to SAS Dates (Date Values - Datetime Values - Time Values)
Preview09:46
Converting Dates stored in text (Character) to Date Values (Numeric)
07:20
Converting Date Values (Numeric) to text (Character)
02:09
Using the INTCK() function to calculate difference of 2 dates (in months, years)
03:57
Using INTNX() function to increment a date (in years, months, qtrs, days, etc)
05:18
Calculate difference between Dates using the DATDIF() function
03:54

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

Requirements

No need to have prior experience with the language. We will teach you from the very basics.
You only need to download a free application to follow along all the exercises we will cover in the videos.
Be passionate on working with data to turn it into insights and knowldedge!

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!

Who this course is for:

People who want to learn SAS Programming
Beginner SAS Programers
Interested in learning SAS Base or Base SAS
SAS Macros , SAS SQL
SAS Procedures, SAS Data Science

Darío Mogollón

Industrial Engineer / Ingeniero Industrial

4.2 Instructor Rating
190 Reviews
7,458 Students
2 Courses

Hello Everyone!, My name is Darío, I am Industrial Engineer, with 7 years of experience in Analytics and Business Intelligence. I've had the chance to work in different industries (Retail, TELCOs, Banking) doing data analysis.

I'd love to help you learn to program in SAS!, I've being programming in this wonderful language for 7 years doing different things, such as ETLs, Reporting, Modelling. I have also taken some SAS courses and done a couple of certifications.

**************************************************************************

Hola a todos!, Mi nombre es Darío, soy Ingeniero Industrial, apasionado por la tecnología y el aprendizaje continuo. Actualmente me intereso en todos los temas relacionados a Data Science. He tenido la oportunidad de trabajar en diferentes industrias como Retail, TELCOs, Banca.

Me gustaría enseñarte a programar en SAS! Cuento con más de 5 años programando con este lenguaje para el análisis de datos y he hecho un par de cursos y certificaciones en esta grandiosa herramienta.

Complete SAS Programming Bootcamp 2019: Go from zero to hero

What you'll learn

Course content

Setting Up Your SAS Environment and Download the Data!2 lectures • 9min

Welcome to the world of SAS!12 lectures • 1hr 6min

Data Manipulation I (Learn to use the powerful Data Step!)8 lectures • 43min

Summarizing Character and Numeric Data! (Proc Freq, Means, Univariate).4 lectures • 22min

Importing Data (Excel, CSV, Tab) in different formats/structures7 lectures • 48min

Data Manipulation II (Controlling Input and Output, Accumulating Totals & more!)7 lectures • 50min

SAS Functions (Character & Numeric Functions)!4 lectures • 32min

Working with Dates Values (Dates - , Datetime - , Time Values6 lectures • 32min

Learning to Combine Data (Concatenating and Merging/Joins)7 lectures • 45min

Do Loops - Processing Data Iteratively6 lectures • 31min

Requirements

Description

Who this course is for:

Instructor