Doing More with SAS Programming from 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.

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.

What's inside

Syllabus

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.

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.

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.

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.

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.

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.

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.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Assumes learners are familiar with SAS programming concepts

Provides detailed coverage of data manipulation techniques

Develops a strong foundation for SAS data manipulation

Builds on knowledge from previous SAS programming courses

Includes exercises and practices to reinforce concepts

Focuses on business applications of SAS

Reviews summary

Enjoyable advanced sas programming course

Learners say this advanced SAS programming course is well received with a majority of largely positive reviews. Students say the course is well-structured and engaging. There is an emphasis on practical hands-on experience with many practice activities, demos, and exercises. The instructor is praised for their clear and concise explanations. Many graduates report gaining valuable knowledge and skills in SAS programming and data analysis.

Be prepared for a challenging but rewarding learning experience.

"Great step-by-step explanation of all concepts!"

"I have to say that this course is much more difficult than the Introduction course (Getting Started with SAS Programming), but that is to be expected!"

"The course was overall very enjoyable, and I gained a lot of valuable insights and knowledge from it."

Clear course structure and organization.

"Very well organized - thoughtfully packaged practice files."

"The course is well-structured and the demos, activities and practices are very good exercises that you can follow and self-learn."

"Brilliant course structure easy to grasp explanation with exercises at every step to test our understanding."

Focus on practical skills with numerous practice exercises.

"Many thanks for Stacy and SAS for this amazing offered continuation course on SAS programming."

"This opened my perspective as to how data analytics can really shape the world."

"The course is well-structured and the demos, activities and practices are very good exercises that you can follow and self-learn."

Instructor does a great job of clearly explaining concepts.

"The instructor delivery of content is very clear and concise."

"Great step-by-step explanation of all concepts!"

"Stacey is the best SAS instructor I can imagine, she is just Amazing!"

There are a few negative reviews, but they are outweighed by the many positive ones.

" The course is good, well-structured and well presented, but most of all easy to follow.The reason for my low rating is that I found out that SAS is far from my favourite program."

"The SAS produces excellent courses, but some of the examples in this SAS course weren't as good as previous SAS courses I've completed."

"I think if we can have more practices, it will be a better experience!"

Career center

Learners who complete Doing More with SAS Programming will develop knowledge and skills that may be useful to these careers:

SAS Programmer

SAS Programmers use their skills in SAS to develop and maintain SAS programs. They work with stakeholders to understand their needs, and then use SAS to develop programs that meet those needs. This course can help you develop the skills you need to become a successful SAS Programmer by teaching you how to use SAS to access, transform, and summarize data, and to develop programs that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for SAS Programmer

Data Analyst

Data Analysts collect and analyze data to help businesses make better decisions. They use their skills in data manipulation and summarization to identify trends and patterns in data, and to develop insights that can help businesses improve their operations, increase their profits, and better serve their customers. This course can help you develop the skills you need to become a successful Data Analyst by teaching you how to use SAS to access, transform, and summarize data.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts use their skills in data analysis to identify and solve business problems. They work with stakeholders to understand their needs, and then use data to develop solutions that meet those needs. This course can help you develop the skills you need to become a successful Business Analyst by teaching you how to use SAS to access, transform, and summarize data, and to develop insights that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Business Analyst

Data Scientist

Data Scientists use their skills in data analysis and machine learning to develop predictive models that can help businesses make better decisions. They work with stakeholders to understand their needs, and then use data to develop models that can predict future outcomes. This course can help you develop the skills you need to become a successful Data Scientist by teaching you how to use SAS to access, transform, and summarize data, and to develop models that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Data Scientist

Machine Learning Engineer

Machine Learning Engineers use their skills in machine learning to develop and maintain machine learning models. They work with stakeholders to understand their needs, and then use machine learning to develop models that can meet those needs. This course can help you develop the skills you need to become a successful Machine Learning Engineer by teaching you how to use SAS to access, transform, and summarize data, and to develop models that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Machine Learning Engineer

Data Engineer

Data Engineers use their skills in data engineering to develop and maintain data pipelines. They work with stakeholders to understand their needs, and then use data engineering to develop pipelines that can meet those needs. This course can help you develop the skills you need to become a successful Data Engineer by teaching you how to use SAS to access, transform, and summarize data, and to develop pipelines that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Data Engineer

Database Administrator

Database Administrators use their skills in database administration to develop and maintain databases. They work with stakeholders to understand their needs, and then use database administration to develop databases that can meet those needs. This course can help you develop the skills you need to become a successful Database Administrator by teaching you how to use SAS to access, transform, and summarize data, and to develop databases that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Database Administrator

Business Intelligence Analyst

Business Intelligence Analysts use their skills in business intelligence to analyze business intelligence data and develop business intelligence models. They work with stakeholders to understand their needs, and then use business intelligence to develop models that can meet those needs. This course can help you develop the skills you need to become a successful Business Intelligence Analyst by teaching you how to use SAS to access, transform, and summarize data, and to develop models that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Business Intelligence Analyst

Data Management Analyst

Data Management Analysts use their skills in data management to analyze data management data and develop data management models. They work with stakeholders to understand their needs, and then use data management to develop models that can meet those needs. This course can help you develop the skills you need to become a successful Data Management Analyst by teaching you how to use SAS to access, transform, and summarize data, and to develop models that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Data Management Analyst

Statistician

Statisticians use their skills in statistics to analyze data and develop statistical models. They work with stakeholders to understand their needs, and then use statistics to develop models that can meet those needs. This course can help you develop the skills you need to become a successful Statistician by teaching you how to use SAS to access, transform, and summarize data, and to develop models that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Statistician

Quantitative Analyst

Quantitative Analysts use their skills in quantitative analysis to analyze quantitative data and develop quantitative models. They work with stakeholders to understand their needs, and then use quantitative analysis to develop models that can meet those needs. This course can help you develop the skills you need to become a successful Quantitative Analyst by teaching you how to use SAS to access, transform, and summarize data, and to develop models that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Quantitative Analyst

Market Researcher

Market Researchers use their skills in market research to analyze market data and develop market research reports. They work with stakeholders to understand their needs, and then use market research to develop reports that can meet those needs. This course can help you develop the skills you need to become a successful Market Researcher by teaching you how to use SAS to access, transform, and summarize data, and to develop reports that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Market Researcher

Financial Analyst

Financial Analysts use their skills in financial analysis to analyze financial data and develop financial models. They work with stakeholders to understand their needs, and then use financial analysis to develop models that can meet those needs. This course can help you develop the skills you need to become a successful Financial Analyst by teaching you how to use SAS to access, transform, and summarize data, and to develop models that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Financial Analyst

Risk Analyst

Risk Analysts use their skills in risk analysis to analyze risk data and develop risk analysis models. They work with stakeholders to understand their needs, and then use risk analysis to develop models that can meet those needs. This course can help you develop the skills you need to become a successful Risk Analyst by teaching you how to use SAS to access, transform, and summarize data, and to develop models that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Risk Analyst

Operations Research Analyst

Operations Research Analysts use their skills in operations research to analyze operational data and develop operational research models. They work with stakeholders to understand their needs, and then use operations research to develop models that can meet those needs. This course can help you develop the skills you need to become a successful Operations Research Analyst by teaching you how to use SAS to access, transform, and summarize data, and to develop models that can help businesses improve their operations and increase their profits.

See salaries and explore the career path for Operations Research Analyst