*This course uses a commercial license from WPS. Anyone interested in full information, visit our disclaimer at the bottom. Thank you!*
This course lets you Learn SAS through example! A Case Study at the end of the course gives you an opportunity to see a real life example, and observe how some of the concepts you learned about are integrated together!
This course covers Base SAS (SAS Base). This is the first course of two. The second course covers SAS SQL. The course is meant for beginners. No prior experience is required. If your goal is to become a SAS programmer or data analyst, or to learn SAS programming, this course is a great start!
Closed Captioning in English available, for those hard of hearing or for people who's first language is not English.
Welcome! You will learn how to code in the SAS statistical programming language, to help you start a career/gain employment, or move up at your current company. If you're studying SAS at a post-secondary institution, this course can not only help you with school projects but prepare you for a career after you complete your education.
SAS is the most used language commercially. SAS is a powerful statistical language and understanding data entry, data management, and data analysis is more important than ever before. Every company needs a data ninja! An expert in data management and data analysis!
Let me tell you what you will learn. In the import section, you'll learn how to import different file types (.txt, .csv, .xlsx), In the working with data section you'll learn how to merge two data sets, filter observations, clean and reduce your data, read dates, create an enumeration variable, and much more. There is a section on Informats/Formats and SAS Input Types (list input, column input, formatted input). In the arrays section, I go into some detail about arrays. As of now, I show you how to use Arrays to recode variables and create new ones. In the Functions section, I cover the Rand function, length/lengthn/lengthc functions, Trim function, compress function, input/put functions, catx function and more! In the visualization section, you'll learn how to make a scatter plot and bar charts. In the statistical (data) analysis section, I'll cover independent t-tests, chi-square analysis, linear regression, and multiple regression. I also cover a few concepts from Macro Programming. The course ends with a Case Study that is taken from real life application, and let's you see how some of the concepts you learned about are integrated together!
Learning the SAS programming language means being able to accomplish the same goal on ANY software the supports SAS language. I personally use WPS. You guys have your own options.
Finally, you have nothing to lose. No risk! You get a 30 day money back guarantee + the course for life (including any new content added after you enroll)!
Enroll now! Your future looks brighter with SAS.
We are not in any way affiliated or associated with SAS Institute. We do not provide, nor do we endorse, a download of SAS University edition for your learning purposes, nor do we personally use SAS software, or SAS logos. We do not link to SAS website, nor do we link to any SAS content, nor do we have screen shots of any of their assets, nor do we distribute it, nor do we suggest it's ours.
We use a commercial license from WPS. The system I use, WPS, is in no way associated with SAS System. Furthermore, whenever you see the phrases "SAS", "SAS Language" and "language of SAS" used in the course content this refers to the computer programming language. If you see phrases like "program", "SAS program", "SAS language program" used in my course, this is used to refer to programs written in the SAS language. These may also be referred to as "scripts", "SAS scripts" or "SAS language scripts".
You will learn how to import a .txt file to SAS. I promise it's super simple!
You will learn how to import a .csv file to SAS. I promise it's super simple!
You will learn how to import a .xlsx file to SAS. I promise it's super simple!
This lesson is about importing an SPSS file. Hope you enjoy it.
Quiz for Importing section.
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.
Here I show you how to standardize your variables!
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.
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.
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.
Creating an enumeration or counting variable is common with survey data!
Quiz for Data section.
In this article style lesson, I write a bit about Informats and Formats!
In this article style lesson I go over Input Types in some detail. I've introduced it in prior videos, but here I go into some depth! I talk about list input, column input and 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.
If you want to convert your character variable to a numeric one (ie so you can do analysis on that variable), you have to use the INPUT function. If you want to change a numeric variable to a character one, you have to use the PUT function.
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!
The software you are using for this course may not able to perform the graphs I will show you. Nevertheless, I show you which graphs other than a scatter plot that you can do. Your place of employment will certainly have it.
This is an overview (example) of t-test independent samples analysis!
Independent samples t-test is one of the more common tests that businesses and corporations do for their data analysis! I'll show you how to to run this test on SAS.
An overview (example) of how chi-square test of independence works.
Here I show you how to perform a chi-square independent groups analysis using SAS.
Short explanation on what regression is about..with focus on linear regression. This is a quick refresher, and not meant to be a comprehensive coverage of the topic. It is added to give you more confidence and clarity when performing this statistical test using SAS.
Learning how to create a macro variable can speed up your coding, by making it easier to modify your data.
Learning how to create a macro can give you great flexibility, and help finish your coding much quicker. Time=money.
The success and fun I had with statistics based courses in University has resulted in my current teaching interests. My interest in data and statistics boils down to my passion for finding the objective truth, and applying these findings in life and business. Currently, I teach five courses. A Statistics course, a SAS course in English, a SAS course in Portuguese (with subtitles, but English instruction), a SAS SQL course, and a Pandas (Python 3 ) course.
O sucesso e diversão que eu tive durante meus cursos de estatística na Universidade resultaram em meu interesse em ensinar. Meu interesse em dados e estatística vêm de minha paixão por encontrar verdades objetivas, e aplicar estas descobertas na vida e no negócio. Atualmente, eu ensino quatro cursos. Um curso de Estatística, um curso de SAS em inglês, um curso de SAS em português (com legendas, mas instruções em inglês) e um curso de Pandas (Python 3).