The WHERE clause allows you to use operators to set conditions and only select what you want from a table. The author will cover the comparison operators, logical operators, and special operators. This clip is from the chapter "SQL...

What if your data file is not separated by a blank space? What if it is separated by a dot (.) or |? The author will explain SAS default delimiters and how to deal with such a problem. This clip is from the chapter "Working with Data" of...

The VERIFY function is super useful for data cleaning purposes (picking up errors) in a dataset. The author will show you one way to use it! This clip is from the chapter "SAS Functions" of the series "Complete SAS Programming Guide -...

This video talks about variable clustering. 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...

Did you know that you can use the set statement to merge as well? 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...

In this video, the author is going to show you how to create or define your OWN formats. This is often necessary, but it does not have to be difficult to understand! This clip is from the chapter "Input Types and Informats + User-Defined...

The author will explain SAS functions. What are they? What can they do? What are arguments? This clip is from the chapter "SAS Functions" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section...

This video explores the types of 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 the Macro facility...

This video focuses on the types of 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 fundamentals...

The TRIM function copies your argument (or parameter) and gets rid of trailing blanks(space). This clip is from the chapter "SAS Functions" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section...

This video explains testing with large datasets. 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...

You will often have to summarize your table and get some statistics. The author will show you how. This clip is from the chapter "SQL Fundamentals" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This...

The author will show you how to use the SUBSTR function, both the right application of it (which allows you to extract a substring) and the left application (which is useful for replacing character value contents). This clip is from the...

This video focuses on subset selection. 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...

This video focuses on storing macros externally. 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...

To build a good SAS model, we have to clearly understand the sources, patterns, and mechanisms of missing data. We don't want to delete data that is critical to us. This clip is from the chapter "SAS Predictive Modeling, Prepare the...

The author will show you two new statements—proc sort and by statements. This will inform you how to sort your data. This clip is from the chapter "Working with Data" of the series "Complete SAS Programming Guide - Learn SAS and Become a...

This video explains about the index and should you even use it. 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...

This video focuses on selecting variable(s) for your Index. 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 author will get into specifics about the SELECT statement. This clip is from the chapter "SQL Fundamentals" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This section focuses on SQL fundamentals.

This video helps you with scoring validation dataset using code. 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...

The author will show you the ease with which you can create a scatter plot with SAS. This clip is from the chapter "Visual Representation of Data" of the series "Complete SAS Programming Guide - Learn SAS and Become a Data Ninja".This...

Do you want to only return the second word (John) from a variable that is storing the concatenated full name of an individual, that is, Fisher, John? Well, now you can! This clip is from the chapter "SAS Functions" of the series...

The author will describe what rules to follow to make sure you can communicate with the compiler that makes sense of SAS code. This clip is from the chapter "SAS Syntax, Data Step Versus Proc Step, SAS Compared to R/Python" of the series...