Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Reading DATES in Data
SAS is not great at dealing with data that has dates, and by default, it does not present them properly; the author will show you what is required to deal with this. This clip is from the chapter "Working with Data" of the series...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Reading Data Instream in Data Step (Typing Data Right into Coding Area)
Sometimes you want to just type your data directly in the syntax. This is logical if you have very little data, and if there is no need to import a file to SAS. The author will show you how to do it. This clip is from the chapter...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - PROC Datasets and WHERE Expression
This video helps you understand PROC datasets and the WHERE expression. This clip is from the chapter "Fundamentals of Utilizing SAS Indexes" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Parameter Estimates
This video explains parameter estimates. This clip is from the chapter "SAS Predictive Modeling, Prepare the Input Variables" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on SAS...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Multicollinearity
This video explains multicollinearity. This clip is from the chapter "SAS Predictive Modeling, Prepare the Input Variables" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on SAS...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - More on the WHERE Expression/Statement
The author will discuss the WHERE expression in some detail. This clip is from the chapter "Working with Data" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on working with data.
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Macro Variable Assignment Rules
This video talks about the macro variable assignment rules. This clip is from the chapter "Macro Facility Fundamentals" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on the Macro...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Macro Programs Introduction
The author will introduce you to Macro programs. This clip is from the chapter "Macro Facility Fundamentals" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on the Macro facility...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Macro Functions 2 (%Scan)
This video focuses on the second macro function, that is %Scan. This clip is from the chapter "Macro Facility Fundamentals" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on the...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Macro Functions (%Index and %Upcase)
This video explains macro functions that is %Index and %Upcase. This clip is from the chapter "Macro Facility Fundamentals" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on the...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - List Input
In this video, you will learn about list input, which is the simplest form of input types but does have some limitations. This clip is from the chapter "Input Types and Informats + User-Defined Formats" of the series "Complete SAS...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - LENGTH, LENGTHN, LENGTHC Functions (Are You Working with a Large Dataset?)
If you work with large datasets (lots of columns/rows), this video will be very useful. Learn about LENGTH, LENGTHC, and LENGTHN functions. This clip is from the chapter "SAS Functions" of the series "Complete SAS Programming Guide -...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Intuition for If-Then/Else and Do, Do-While, Do-Until
Before we start using decision and looping structures in actual SAS code, it is important to first get an intuitive sense of how these structures work. The author will use some diagrams to enhance learning. This clip is from the chapter...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Intro to Indexes/Indices
This video provides an introduction to indexes/indices. This clip is from the chapter "Fundamentals of Utilizing SAS Indexes" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on the...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Index Options
This video explains the index options. This clip is from the chapter "Fundamentals of Utilizing SAS Indexes" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on the fundamentals of...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Import .XLSX
This video demonstrates the importing of .XLSX files. Here, the author will give you a proc import SAS example. So far, you have seen how to use the data step to import datasets. In this video, you will utilize proc import to import a...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Import .txt
In this video, you will learn how to import a .txt file to SAS. This clip is from the chapter "Importing" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on importing different file...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - If-Then Conditional Logic
If-then logic lets you subset data and group observations when the observations meet the outlined conditions. This clip is from the chapter "Working with Data" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - How to Compare Tables with SAS SQL
This video helps you understand how to compare tables with SAS SQL. This clip is from the chapter "Practical Application of SAS SQL" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Handling Common Tasks with an Indexed Dataset
This video focuses on handling common tasks with an indexed dataset. This clip is from the chapter "Fundamentals of Utilizing SAS Indexes" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Formatted Input and Informats
When you have to use Informats to read your data properly, it is referred to as formatted input. This clip is from the chapter "Input Types and Informats + User-Defined Formats" of the series "Complete SAS Programming Guide - Learn SAS...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Flexible Programming 1 - Combining multiple raw data files vertically
A flexible way to concatenate a bunch of raw data files vertically. In this video, you will learn how to combine multiple raw data files vertically. This clip is from the chapter "Advanced Techniques – Flexibilities and Efficiency" of...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Finding Duplicate Observations
This video demonstrates finding duplicate observations. This clip is from the chapter "Practical Application of SAS SQL" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on the...
Curated Video
Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Filtering Observations (So Only Some Data Shows Up)
Sometimes you only want a certain part of your dataset to show up. The author will show you how this is possible in SAS. If you are in the real estate business, maybe the boss will ask you to show him a list of only the homes that cost...