We may earn an affiliate commission when you visit our partners.
Course image
Ermin Dedic

SAS Programming Complete is perfect for beginners but delves into more intermediate topics. For example, you will learn how to develop a predictive model.

Read more

SAS Programming Complete is perfect for beginners but delves into more intermediate topics. For example, you will learn how to develop a predictive model.

If you are using SAS Enterprise Guide and want to learn how to code/program instead of using the point-and-click interface, this course is ideal. The course also introduces SAS model building.

The first part of the course utilizes the Data step, the 2nd part looks at SAS SQL, and the third part looks at Macro Programming/Programs

Additionally, I have added a section on SAS Predictive Modeling using Logistic Regression. Here, we will build a predictive model (also known as Predictive Analytics)

While the course is for beginners, it is comprehensive and covers some advanced topics. This also allows students who have previous experience to benefit from the course. Furthermore, since you get the LIFE course, you can use it as a resource anytime.

SAS programming continues to be the language of choice for most enterprises/corporations. In 2018, 92% of Fortune 100 companies utilized SAS. It is the go-to for many industries, including banking/finance, insurance, healthcare, pharmaceuticals, and automotive.

My SAS training course was also developed to help you become a certified SAS Specialist: Base Programming Certified. I have received numerous private messages from students who have passed the SAS Base exam, work-related exams, or interviews because of this course. I love hearing this.

The lessons in this course are meant to be taken in order, as each lesson builds upon knowledge, and may mention some crucial 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 specific lines of code.

Nevertheless, you will learn a lot.

So, whether you want to start a career/gain employment, or move up at your current company, this course can help you with school projects and prepare you for a career after you complete your education.

Learning SAS programming means you can accomplish the same goal with any software supporting the SAS language.

Finally, you have nothing to lose. No risk. You get a 30-day money-back guarantee.

Enroll now. Your future looks brighter with SAS training.

We do not provide, nor do we endorse, a download of the SAS University edition for your learning purposes, nor do we personally use SAS software or SAS logos. We make no mention of them (their website, content, screenshots 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 the SAS System.

Enroll now

What's inside

Learning objectives

  • Discover the data step, the primary way to program in sas.
  • Discover the proc step, a more specialized kind of processing that is utilized for more particular tasks.
  • Apply sas sql, the sas interpretation of sql.
  • Learn techniques to decrease the amount of code you have to type, and learn to deal with big data.
  • Grow your skill by learning how to create a sas model for advanced analytics.
  • Obtain skills needed to pass sas certified specialist: base programming exam.

Syllabus

A Hello video, installation of SAS, etc
SAS Enterprise Guide, SAS Studio, WPS ***very important***
SAS Studio/SAS OnDemand for Academics - Register, Upload, Run Code
Read more
WPS (no longer suggested)
All the Data-sets are attached to this Lecture!
Common Problems With Install/Upload/Videos (Watch for Best Course Experience!)
How to import .txt, .csv. and .xlsx files into SAS

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!

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.

fundamentals explored

I compare the data step vs. the proc step.

I describe what rules to follow to make sure you can communicate with the compiler that makes sense of SAS code.

Note: This video is meant to show you the similarities and differences between the languages (not showcase the capabilities of the World Programming System). You cannot do this on SAS OnDemand for Academics.

I manually create data with R, Python, and SAS to give you an idea about the similarities and differences between the 3 popular programming languages.

delimiters, creating new variables, sorting observations, filtering observations, merging two datasets, and more!

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.

Automatic variables do their work in the background but they can be used explicitly as well to perform certain tasks. In this lecture, I look at the _Error_ and _N_ automatic 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.

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.

Assignment 0.5: Integration Assignment 0.5
I didn't want to bore you with too much import stuff but if you want to learn some differences between importing a .txt vs. csv..here is your change.

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

A section devoted to input types, relation to informats, and user-defined formats.

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.

In this section I cover Arrays in some detail.

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.

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.

I cover some of the most common functions that are used.

I explain SAS Functions. What are they? What can they do? What are arguments?

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!

Help Me Understand Your Needs

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!

assignments
Integration Assignments
Integration of Skills 1
Integration of Skills 2
Ratings/Reviews
In this section, I want to add another layer to the learning. I want to show you how flexible and efficient you can make your programs without using Macro programming.

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

So you know how to import, filter, merge, and play with your data..but how do you represent it visually?

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

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.

T-tests and chi-square
Some information for this section

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.

I cover linear and multiple regression

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.

Performing the Linear Regression
Performing Multiple Regression
here I will post different case studies that help you integrate a lot of the concepts learned, and present a real situation where these concepts would be applied!

An important note before you start!

In this case study, I try to integrate some of the concepts you have learned throughout the course, and apply these integrated concepts to a real life situation/example. This is a health care related case study.

This is part 2.

Code for Case Study
Congrats on Finishing Part 1: Data Step
In this section, I'll show you the SAS SQL fundamentals. SAS SQL Syntax, different types of joins, creating tables, etc

I go over the basic elements of SAS SQL syntax.

The WHERE clause allows you to use operators to set conditions and only select what you want from a table. I go over comparison operators, logical operators, and special operators.

I get into the specifics about the SELECT statement. 

I discuss how you can use case logic/expression.

You'll often have to summarize your table and get some statistics..I'll show you how.

SAS SQL Assignment 1
SAS SQL Assignment 1 Solution
Using SAS SQL to do an inner join, left/right join, full join, and how to join three tables.
How to Perform an Inner Join
How to Join Three Tables

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Introduces SAS SQL, a widely used language for data management and analysis in various industries
Provides a comprehensive overview of the SAS programming language, starting from basics to advanced topics
Teaches practical skills in SAS programming, preparing learners for job opportunities that require SAS expertise
Covers intermediate and advanced SAS topics, making it suitable for learners with some programming experience
Offers a 30-day money-back guarantee, providing learners with flexibility and reassurance
May require learners to have access to SAS software, which could be a potential barrier for those without access

Save this course

Save SAS Programming Complete: Learn SAS and Become a Data Ninja to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SAS Programming Complete: Learn SAS and Become a Data Ninja with these activities:
Review SAS Basics and Data Manipulation
Familiarize yourself with SAS basics and data manipulation techniques to enhance your understanding of the course concepts.
Browse courses on Data Manipulation
Show steps
  • Review data types and their properties.
  • Practice reading and writing data using SAS datasets.
  • Refresh your knowledge of data manipulation commands like filtering, sorting, and merging.
Practice Data Exploration and Analysis
Strengthen your understanding of data exploration and analysis techniques by completing practice drills.
Browse courses on Data Exploration
Show steps
  • Analyze data using descriptive statistics and visualization techniques.
  • Identify and interpret patterns and trends in data.
  • Apply data exploration and analysis techniques to real-world scenarios.
Participate in a SAS Study Group
Enhance your understanding and retention by joining a study group where you can discuss concepts and share knowledge.
Browse courses on SAS
Show steps
  • Find a study group or create one with peers.
  • Meet regularly to discuss course topics and assignments.
  • Share resources and support each other's learning.
Three other activities
Expand to see all activities and additional details
Show all six activities
Explore Advanced SAS Features
Expand your knowledge of SAS by following guided tutorials on advanced features such as macro programming and SAS SQL.
Browse courses on SAS
Show steps
  • Learn how to create and use macros to automate tasks.
  • Leverage SAS SQL to perform complex data queries and analysis.
Contribute to SAS Community Projects
Get involved in SAS community projects to connect with other professionals and expand your knowledge through real-world contributions.
Browse courses on Open Source
Show steps
  • Find SAS community projects or open-source initiatives.
  • Identify opportunities to contribute, such as reporting bugs or providing code.
  • Join online discussions and forums to connect with the community.
Develop a SAS Model for Predictive Analytics
Apply your SAS skills to develop a predictive model for a real-world problem.
Browse courses on Predictive Analytics
Show steps
  • Identify a suitable business problem and collect relevant data.
  • Prepare and clean the data for analysis.
  • Build and evaluate a predictive model using SAS.
  • Interpret and present the results of your analysis.

Career center

Learners who complete SAS Programming Complete: Learn SAS and Become a Data Ninja will develop knowledge and skills that may be useful to these careers:

Reading list

We haven't picked any books for this reading list yet.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to SAS Programming Complete: Learn SAS and Become a Data Ninja.
SAS Programming BASE Certification Course for SAS...
Most relevant
SAS® Programming for Distributed Computing in SAS® Viya®
Most relevant
Preparing for the SAS® Viya® Programming Certification...
Most relevant
Practical SAS Programming and Certification Review
Most relevant
Getting Started with SAS Programming
Most relevant
Using SAS Viya REST APIs with Python and R
Most relevant
Practicing for the SAS Programming Certification Exam
Most relevant
Preparing for the SAS Programming Certification Exam
Most relevant
CASL Programming for Distributed Computing in SAS® Viya®
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser