Doing More with SAS Programming (Coursera)

Offered by SAS,
Doing More with SAS Programming (Coursera)

This course is for business analysts and SAS programmers who want to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the Getting Started with SAS Programming course and is not recommended for beginning SAS software users.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

In this course you learn how to understand and control DATA step processing, create an accumulating column and process data in groups, manipulate data with functions, convert column type, create custom formats, concatenate and merge tables, process repetitive code, and restructure tables. This course addresses Base SAS software.
Before attending this course, you should be able to write DATA step code to access data, subset rows and columns, compute new columns, and process data conditionally. You should also be able to sort tables using the SORT procedure and apply SAS formats.
Course 2 of 3 in the SAS Programmer Professional Certificate

Syllabus

WEEK 1
Course Overview and Data Setup
In this module you get an overview of what you learn in this course and you set up the software and data you use for activities and practices in the course.
Controlling DATA Step Processing
In this module, we dig deeper into the DATA step. You learn how the DATA step processes data behind the scenes. Then you use this knowledge to control when and where the DATA step outputs rows to new tables.

WEEK 2
Summarizing Data
In this module, you learn new syntax that enables you to alter the default behavior of the DATA step to solve a problem. First you learn to create an accumulating column, or in other words generate a running total. Then you learn to process data in groups, so you can perform an action when each group begins or ends.

WEEK 3
Manipulating Data with Functions
In this module, you learn to use some new functions that enable you to manipulate numeric, date, and character values. In addition, you learn to use functions that change a column from one data type to another.

WEEK 4
Creating and Using Custom Formats
In this module, you learn to create and use custom formats to enhance the way your data is displayed in a table or report.

WEEK 5
Combining Tables
In this module, we take a comprehensive look at combining tables by using the DATA step. You learn to concatenate tables, merge tables, and identify matching and nonmatching rows.

WEEK 6
Processing Repetitive Code
In this module, you learn to save time by taking advantage of iterative processing with DO loops. First you learn to create an iterative DO Loop, then you learn to create conditional DO loops.

WEEK 7
Restructuring Tables
In this module, you learn techniques that can be used to transpose or restructure a table. First you learn to restructure data with the DATA step. Then you learn to restructure data by using the TRANSPOSE procedure.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Statistics and Data Analysis with Excel, Part 1 (Coursera) Coursera
University of Colorado Boulder

Statistics and Data Analysis with Excel, Part 1 (Coursera)

Designed for students with no prior statistics knowledge, this course will provide a foundation for further study in data science, data analytics, or machine learning. Topics include descriptive statistics, probability, and discrete and continuous probability distributions. Assignments are conducted in Microsoft Excel (Windows or Mac versions). Designed to be taken with the follow-up course, “Statistics and Data Analysis with Excel, Part 2.”

Sep 28th 2026
5-12 Weeks
Advanced Linear Models for Data Science 2: Statistical Linear Models (Coursera) Coursera
Johns Hopkins University

Advanced Linear Models for Data Science 2: Statistical Linear Models (Coursera)

Welcome to the Advanced Linear Models for Data Science Class 2: Statistical Linear Models. This class is an introduction to least squares from a linear algebraic and mathematical perspective. Before beginning the class make sure that you have the following: a basic understanding of linear algebra and multivariate calculus; a basic understanding of statistics and regression models; at least a little familiarity with proof based mathematics; basic knowledge of the R programming language.

Sep 28th 2026
4 Weeks
Case studies in business analytics with ACCENTURE (Coursera) Coursera
ESSEC Business School

Case studies in business analytics with ACCENTURE (Coursera)

This course is RESTRICTED TO LEARNERS ENROLLED IN Strategic Business Analytics SPECIALIZATION as a preparation to the capstone project. During the first two MOOCs, we focused on specific techniques for specific applications. Instead, with this third MOOC, we provide you with different examples to open your mind to different applications from different industries and sectors. The objective is to give you an helicopter overview on what's happening in this field. You will see how the tools presented in the two previous courses of the Specialization are used in real life projects.

Sep 21st 2026
3 Weeks
Bayesian Statistics: Mixture Models (Coursera) Coursera
University of California, Santa Cruz

Bayesian Statistics: Mixture Models (Coursera)

Bayesian Statistics: Mixture Models introduces you to an important class of statistical models. The course is organized in five modules, each of which contains lecture videos, short quizzes, background reading, discussion prompts, and one or more peer-reviewed assignments. Statistics is best learned by doing it, not just watching a video, so the course is structured to help you learn through application.

Sep 21st 2026
5-12 Weeks
Process Mining: Data science in Action (Coursera) Coursera
Eindhoven University of Technology

Process Mining: Data science in Action (Coursera)

Process mining is the missing link between model-based process analysis and data-oriented analysis techniques. Through concrete data sets and easy to use software the course provides data science knowledge that can be applied directly to analyze and improve processes in a variety of domains. Data science is the profession of the future, because organizations that are unable to use (big) data in a smart way will not survive. It is not sufficient to focus on data storage and data analysis. The data scientist also needs to relate data to process analysis.

Sep 21st 2026
5-12 Weeks
Global Statistics - Composite Indices for International Comparisons (Coursera) Coursera
University of Geneva

Global Statistics - Composite Indices for International Comparisons (Coursera)

In this course on global statistics, offered by the University of Geneva jointly with the ETH Zürich KOF, you will learn the general approach of constructing composite indices and some of resulting problems. We will discuss the technical properties, the internal structure (like aggregation, weighting, stability of time series), the primary data used and the variable selection methods. These concepts will be illustrated using a sample of the most popular composite indices. We will try to address not only statistical questions but also focus on the distinction between policy-, media- and paradigm-driven indicators.

Sep 28th 2026
5-12 Weeks
Necessary Condition Analysis (NCA) (Coursera) Coursera
Erasmus University Rotterdam

Necessary Condition Analysis (NCA) (Coursera)

Welcome to Necessary Condition Analysis (NCA). NCA analyzes data using necessity logic. A necessary condition implies that if the condition is not in place, there will be guaranteed failure of the outcome. The opposite however is not true; if the condition is in place, success of the outcome is not guaranteed.

Sep 28th 2026
5-12 Weeks
Statistical Thinking for Industrial Problem Solving, presented by JMP (Coursera) Coursera
SAS

Statistical Thinking for Industrial Problem Solving, presented by JMP (Coursera)

Statistical Thinking for Industrial Problem Solving is an applied statistics course for scientists and engineers offered by JMP, a division of SAS. By completing this course, students will understand the importance of statistical thinking, and will be able to use data and basic statistical methods to solve many real-world problems.

Sep 21st 2026
5-12 Weeks
Ethical Issues in Data Science (Coursera) Coursera
University of Colorado Boulder

Ethical Issues in Data Science (Coursera)

Computing applications involving large amounts of data – the domain of data science – impact the lives of most people in the U.S. and the world. These impacts include recommendations made to us by internet-based systems, information that is available about us online, techniques that are used for security and surveillance, data that is used in health care, and many more. In many cases, they are affected by techniques in artificial intelligence and machine learning.

Sep 28th 2026
5-12 Weeks
SQL: A Practical Introduction for Querying Databases (Coursera) Coursera
IBM

SQL: A Practical Introduction for Querying Databases (Coursera)

Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and manipulating data in databases. A working knowledge of databases and SQL is a must for anyone who wants to start a career in Data Engineering, Data Warehousing, Data Analytics, Data Science or Business Intelligence. The purpose of this course is to help you learn and apply foundational and intermediate knowledge of the SQL language, and become familiar with many relational database (RDBMS) concepts along the way.

Sep 21st 2026
5-12 Weeks
Gender Foundations in Health Data: A Data for Health Course (Coursera) Coursera
Johns Hopkins University

Gender Foundations in Health Data: A Data for Health Course (Coursera)

Welcome to Gender Foundations in Health Data: A Data for Health course. This course was developed from an online seminar series of the same name, that was hosted by Johns Hopkins University Bloomberg School of Health in 2021-22. The course instructors are Drs. Michelle Kaufman and Tahilin Sanchez Karver. This course will raise learners' awareness of the necessity of utilizing a gender lens in global public health data, policy, and practice, feature how-tos and key examples of integration of gender in data collection, analysis, and use from Data for Health partners.

Sep 28th 2026
1 Week
Empathy, Data, and Risk (Coursera) Coursera
University of Illinois at Urbana-Champaign

Empathy, Data, and Risk (Coursera)

Risk Management and Innovation develops your ability to conduct empathy-driven and data-driven analysis in the domain of risk management. This course introduces empathy as a professional competency. It explains the psychological processes that inhibit empathy-building and the processes that determine how organizational stakeholders respond to risk.

Sep 28th 2026
4 Weeks