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

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

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

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

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

This video explains feature engineering. This clip is from the chapter "SAS Predictive Modeling, Evaluation Metrics" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on SAS...

This video explains how to not lose track of our own macro variables. 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...

Independent samples t-test is one of the more common tests that businesses and corporations do for their data analysis. The author will show you how to run this test on SAS. This clip is from the chapter "Statistical Analysis" of the...

You might be more familiar with the for loop, but the DO loop is the same concept. 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...

This video explains debugging options in detail. 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...

In this video, you will see the difference between data step and proc step. This clip is from the chapter "SAS Syntax, Data Step Versus Proc Step, SAS Compared to R/Python" of the series "Complete SAS Programming Guide - Learn SAS and...

First, the author will show you how to use the keep and drop statements in SAS. If you want to reduce your data by keeping or getting rid of certain variables, the author will take you step-by-step to show you how. Then he will show you...

This video helps you with the data audit. This clip is from the chapter "SAS Model – Predictive Modeling, Understanding the Problem and the Data" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This...

This video explains how to customize the way you sort. 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...

Learning how to create a macro variable can speed up your coding, by making it easier to modify your data. This clip is from the chapter "Macro Facility Fundamentals" of the series "Complete SAS Programming Guide - Learn SAS and Become a...

This video will help you with creating a macro example where you will be calculating average sales for multiple years. This clip is from the chapter "Macro Facility Fundamentals" of the series "Complete SAS Programming Guide - Learn SAS...

The author will show you how to create a macro that creates different sales reports depending on the day. This clip is from the chapter "Macro Facility Fundamentals" of the series "Complete SAS Programming Guide - Learn SAS and Become a...

This video helps in considering the output from PROC MI. 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...

The compress function allows you to remove characters from strings. It also removes leading, trailing, and between blanks. This clip is from the chapter "SAS Functions" of the series "Complete SAS Programming Guide - Learn SAS and Become...

This video demonstrates the common problems with install/upload. Do Watch this video to understand how to gain or grasp the concepts for the best course experience. This clip is from the chapter "Introduction to the Course" of the series...

In this video, you will learn about column input, which has some advantages over list input. The author will cover what those advantages are! This clip is from the chapter "Input Types and Informats + User-Defined Formats" of the series...

The coalesce function will return the first value that is NOT MISSING from a list of numeric arguments. I use an example where you store someone's home phone number and cell #. It's a good example as it is normal to sometimes have a home...

An overview (example) of how chi-square test of independence works. This clip is from the chapter "Statistical Analysis" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on...

CATX function will remove both leading and trailing blanks, insert a delimiter (or separator), and return a concatenated (merged) character string. This clip is from the chapter "SAS Functions" of the series "Complete SAS Programming...