Learn SAS and Become a Data Ninja #1
4.2 (1,077 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,222 students enrolled

Learn SAS and Become a Data Ninja #1

Learn SAS. Base SAS. SAS Base.This is a SAS Programming Course For Beginners. SAS Base Programming.
Bestseller
4.2 (1,077 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,222 students enrolled
Created by Ermin Dedic
Last updated 12/2018
English
English [Auto-generated], Indonesian [Auto-generated], 4 more
  • Italian [Auto-generated]
  • Polish [Auto-generated]
  • Romanian [Auto-generated]
  • Thai [Auto-generated]
Current price: $11.99 Original price: $194.99 Discount: 94% off
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 10 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Apply basic to intermediate SAS skills.
  • Learn from Example: A Health Care related case study gives you a real life example!

  • Understand how to import data, merge data, filter your observations, clean your data, use conditional logic, and much more!

  • Apply SAS functions (RAND, LENGTH,TRIM, COMPRESS, and more).
  • Apply Arrays in situations where it makes sense, to make your life easier
  • Be able to show your data visually (ie graphs).
  • Be able to do statistical analysis (t-tests, chi square, linear regression, multiple regression)
  • Apply Macro Programming can give you greater flexibility and save you time!
Requirements
  • Internet connection
Description

*This course uses a commercial license from WPS. Anyone interested in full information, visit our disclaimer at the bottom. Thank you!*

------------------------------------------------------------------------

This is the 1st course in my SAS series. Integration Assignments and a Case Study at the end of the course will test your understanding!

Welcome! Let this course help you obtain SAS certification!  

The lessons in this course are meant to be taken in order, as each lesson builds up on knowledge, and may mention some important ideas/concepts. If you skip videos, it may appear that some aspects are not being explained. For example, if you skip the import.txt lecture because you only care about importing .csv files, you may miss explanations about certain lines of codes.

Nevertheless, you will learn a lot!

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! 

After this section, you will get an opportunity to test your skills by trying the Integration Assignments.

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

DISCLAIMER

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



Who this course is for:
  • Individuals that are considering a career, or want to gain employment, with the biggest corporations/enterprises out there!
  • Those new to SAS syntax and or students looking for a refresher. No prior programming knowledge is required.
  • Those who want to know how to use the most important data analysis software/language out there!
Course content
Expand all 61 lectures 04:50:21
+ Introduction
5 lectures 09:22

What you can expect to learn in the course!

Preview 02:11
All the files you need to follow along!
00:12
Installing/Uploading files (very important!)
04:47
How to Find, Install, and Use SAS Studio/SAS OnDemand For Academics
01:16
How to Find, Install, and Use WPS
00:56
+ Importing
6 lectures 22:31
Important Note About Watching Course
00:16

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

Preview 02:00

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

Import .csv
06:05

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

Import .XLSX
04:03

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

Importing SPSS file with SAS language
03:33
How to Save Data-sets Permanently
06:34

Quiz for Importing section.

Quiz for Importing
2 questions
+ Working with Data
15 lectures 01:09:07

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

Data Set Options
04:39

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!

What if your data is separated by a dot or something else? (delimiters)
02:59

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.

Reading data instream in data step (typing data right into coding area)
05:12

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.

Reading DATES in data
06:07

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.

Creating variables/Calculations
04:04

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

More on Creating New Variables
04:16

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.

Filtering Observations (so only some data show up)
02:08

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

If-then Conditional Logic
05:40

I discuss the WHERE expression in a bit of detail.

More on the WHERE Expression/Statement
03:56

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

Preview 03:25

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

Merging Two Data Sets
03:38

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

Using SET statement to Merge
03:41

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.

Data Reduction and Cleaning your Data
06:48

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

LENGTH statement
08:08

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

Creating a Counting (Enumeration) Variable
04:26

Quiz for Data section.

Data Section Quiz
7 questions
+ Input Types and Informats + User-defined formats
4 lectures 22:27

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

List Input
04:18

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

Column Input
04:20

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

Formatted Input And Informats
05:55

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!

User Defined Formats
07:54

Quiz for Informats/Formats and SAS Input Styles.

Informats/Formats and SAS Input Style Quiz
3 questions
+ Arrays
2 lectures 12:03

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.

Arrays 1 (Recoding Variables)
07:05

Constructing new variables manually is a tedious process when you have many variables that you are working with..let me teach you a simpler way.

Preview 04:58
+ SAS Functions
10 lectures 46:14

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.

RAND Function (producing a sample with distribution of your choice)
05:29

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

LENGTH, LENGTHN, LENGTHC functions (are you working with a large data set?)
06:56

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

TRIM function (want to get rid of trailing blanks?)
02:55

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

COMPRESS Function (remove characters from string, and all types of blanks)
03:53

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.

Preview 07:42

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

CATX function
03:15

 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!

SCAN function
03:28

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.

Coalesce function
03:24

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!

Verify function
05:04

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

Substr function
04:08

A quiz for the Functions section!

Functions Quiz
5 questions
+ Assignments
1 lecture 00:15
Integration Assignments
00:15
The assignment will test how well you are able to integrate the skills you have learned. Please see the instruction video for instructions on what you have to do for the assignment, and then check the solutions with the solutions video.
Integration of Skills 1
1 question
Please view the instruction video first. Really important. You can use the attached resource (it's the assignment questions), while you are working on your assignment. Then have a look at the solution video.
Integration of Skills 2
1 question
+ Visual representation of data
2 lectures 06:57

I show you the ease at which you can create a scatter plot with SAS.

Preview 04:45

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.

Bar Graph
02:12
+ Statistical Analysis
5 lectures 20:03
Some information for this section
00:10

This is an overview (example) of t-test independent samples analysis!

T-test independent samples overview (example)
07:03

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.

Doing an Independent samples t-test analysis
03:24

An overview (example) of how chi-square test of independence works.

Chi-square independence overview (example)
06:08

Here I show you how to perform a chi-square independent groups analysis using SAS.

Doing a Chi-square (independent groups) analysis
03:18
+ Statistical Analysis - Part 2 (Linear and Multiple Regression)
3 lectures 11:18

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.

Refresh Your Memory - Regression Edition
03:30
Performing the Linear Regression
04:10
Performing Multiple Regression
03:38