SAS Programming Complete; Learn SAS and Become a Data Ninja

You will learn how to import a .csv file to SAS. I promise it's super simple!

Here I give you a proc import sas example. So far you have seen how to use the data step to import data-sets. In this video I utilize proc import to import a .xlsx file.

Quiz for Importing section.

I compare the data step vs. the proc step.

Data set options can give you control over your dataset or dataset variables.

What if your data file is not separated by a blank space? What if it is separated by a dot (.) or |. I'll explain SAS default delimiters, and how to deal with such a problem!

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. I show you how to do it.

SAS is not great at dealing with data that has dates, and by default it does not present them properly, I will show you what is required to deal with this.

Here I show you how to create new variables with the current data that you have. Often new variables utilize current variables, so calculations are often required.

More on creating new variables, including the type of expressions that you can utilize.

Sometimes you only want certain part of your data set to show up.  I'll show you how this is possible in SAS. If you are in the real estate business, maybe the boss asks you to show him list of only the homes that cost more than 250k.

Before we start using decision and looping structures in actual SAS code, I thought it was important to first get an intuitive sense of how these structures work. I use some diagrams to enhance learning.

If-then logic lets you subset data and group observations when the observations meet the outlined conditions.

You might be more familiar with the for loop but the DO loop is the same exact concept.

There are 4 forms of Do Group Processing, 3 of the forms do not involve a counter/index variable.

I discuss the WHERE expression in a bit of detail.

Summary of Key Differences between WHERE and IF Conditions to Subset Data Sets

I show you two new statements..proc sort and by statements. This will inform you how to sort your data.

I'll show you how you can merge data from two different .txt files. It is super simple to do in SAS.

Did you know that you can use the set statement to merge as well?

First, I 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, I'll take you step by step to show you how. Then I show you the rename and label statements that help make your data more "clean". This includes renaming your original variables and labeling those variables.

You want to make sure to allocate the proper number of bytes for your variables, and in this lecture, I show you how!

Creating an enumeration or counting variable is common with survey data!

Quiz for Data section.

This lesson is about importing an SPSS file. Hope you enjoy it.

List input is the most simple form of Input Types but does have some limitations.

Column Input has some advantages over List Input. I cover what those advantages are!

When you have to use Informats to read your data properly..this is referred to as formatted input. 

In this lesson, I'm going to show you how to create or define your OWN formats. This is often neccesary, but it does not have to be difficult to understand!

Quiz for Informats/Formats and SAS Input Styles.

Recoding variables can be time consuming if you go variable by variable..let me show you an easier way! We utilize the do end loop.

I show you how to use the rand function. This function allows you to produce a sample (random numbers) with a distribution of your choosing.

If you work with large data sets (lots of columns/rows), this lesson will be very useful. Learn about LENGTH, LENGTHC, and LENGTHN functions.

The TRIM function copies your argument(or parameter), and gets rid of trailing blanks(space).

Compress function allows you to remove characters from strings. It also removes leading, trailing, and between blanks.

CATX function will remove both leading and trailing blanks, insert a delimiter (or separator), and return a concatenated (merged) character string.

 Do you want to only return the 2nd word (John) from a variable that is storing the concacated full name of an individual ie Fisher, John. Well now you can!

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 home number but no cell # contact, and the other way around. Well, if there is a value to return, ie at least a home number or cell are present, it will return that available number for you.

The VERIFY function is super useful for data cleaning purposes (ie picking up errors) in a data set. I'll show you one way to use it!

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

A quiz for the Functions section!

A flexible way to concatenate a bunch of raw data files vertically.