We may earn an affiliate commission when you visit our partners.
Stacey Syphus

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.

Read more

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.

Enroll now

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.
Read more

Traffic lights

Read about what's good
what should give you pause
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

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Practical intermediate sas programming skills

According to learners, this course is a valuable next step after the introductory SAS programming course, particularly praised for its focus on intermediate data manipulation techniques. Students found the hands-on exercises and practical examples especially helpful for understanding concepts like DATA step processing control, combining tables (merging and concatenating), and restructuring data with PROC TRANSPOSE. While the instructor is generally clear, some noted the pace can be fast and a solid understanding of the prerequisites is crucial to keep up. Overall, it's highly regarded for providing relevant skills applicable in professional settings.
Solid follow-up to beginner course.
"Perfect continuation after finishing 'Getting Started with SAS Programming'."
"It successfully takes the beginner concepts and expands upon them significantly."
"This course provides a solid foundation for more advanced SAS topics."
"It ties together different concepts effectively for intermediate users."
Concepts explained clearly and well.
"The instructor explains the more complex DATA step logic very clearly."
"I found the explanations on merging data particularly easy to understand."
"Concepts are broken down well, making it digestible."
"The material on functions and formats was presented effectively."
Teaches useful, real-world methods.
"Learned data manipulation techniques I can immediately apply in my job."
"The content on merging and transposing tables is highly relevant for data analysis roles."
"Great course for boosting skills needed for intermediate level SAS work."
"Provides methods that are practical and widely used in industry."
Course includes useful, hands-on exercises.
"The hands-on exercises were very helpful in cementing the concepts learned."
"I really appreciated the practical examples provided; they were easy to follow."
"Plenty of useful demonstrations and coding practices that relate to real work scenarios."
"The labs are well-designed and reinforce the lecture material effectively."
The pace might feel quick for some.
"Sometimes the course moved a bit too quickly for me, especially on new functions."
"I had to pause and rewatch lectures often to fully grasp everything."
"While efficient, the pace might challenge those less familiar with programming concepts."
"Could benefit from slowing down slightly on certain complex topics."
Need strong base before taking this.
"Make sure you are very comfortable with the basics from 'Getting Started' first."
"This course definitely builds on previous knowledge, it's not for beginners."
"The pace assumes you already know the fundamental SAS syntax and concepts."
"Having a solid foundation in basic DATA step programming is essential here."

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 Doing More with SAS Programming with these activities:
Read 'The Little SAS Book'
Gain a solid foundation in SAS data manipulation techniques by reading this introductory textbook. It covers essential concepts, syntax, and examples to help you get started with SAS.
Show steps
  • Read through the chapters on data manipulation.
  • Complete the practice exercises provided in the book.
Refresher: SAS Programming Basics
Review essential SAS concepts and syntax to enter this class with confidence. Understand SAS Program Structure, Data Types, Arrays & More.
Browse courses on SAS Programming
Show steps
  • Review SAS documentation on data types.
  • Complete online tutorials on SAS arrays.
  • Practice writing simple SAS programs to manipulate data.
Follow SAS Online Tutorials
Supplement your learning by exploring interactive SAS tutorials. Gain hands-on experience with data manipulation techniques and reinforce your understanding through practical examples.
Browse courses on Online Learning
Show steps
  • Identify reputable SAS tutorial websites or platforms.
  • Choose tutorials that align with your learning goals.
  • Follow the tutorials step-by-step and practice the code.
Three other activities
Expand to see all activities and additional details
Show all six activities
Practice Data Manipulation Drills
Reinforce your understanding of data manipulation techniques by solving a series of challenging exercises. Learn to subset data, create new variables, and work with different data types.
Browse courses on Data Manipulation
Show steps
  • Solve practice problems on data subsetting.
  • Create new variables using different SAS functions.
  • Manipulate dates and times using SAS date functions.
Participate in a SAS Study Group
Connect with fellow students and engage in discussions to deepen your understanding of SAS data manipulation. Collaborate on problem-solving, share insights, and learn from each other's experiences.
Show steps
  • Find a study group or create your own with classmates.
  • Attend regular study sessions and actively participate in discussions.
  • Work together on SAS exercises and projects.
Create a SAS Data Manipulation Tutorial
Solidify your knowledge by creating a comprehensive tutorial that explains data manipulation techniques in SAS. Share your tutorial with others to enhance your understanding and help others learn.
Browse courses on Data Manipulation
Show steps
  • Choose a specific data manipulation topic to focus on.
  • Write clear and concise explanations of the SAS code and techniques.
  • Include examples and practice exercises to illustrate the concepts.
  • Publish your tutorial online or share it with classmates.

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

Reading list

We've selected eight books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Doing More with SAS Programming.
This specialized book covers the use of SAS for data science and analytics, including machine learning and predictive modeling.
Is the official reference for the SAS macro language. It provides a comprehensive overview of the macro language, including syntax, functions, and examples. It valuable resource for both beginners and experienced SAS users.
Provides a comprehensive overview of SAS procedures. It covers a wide range of procedures, from basic data manipulation to advanced statistical analysis. It valuable resource for both beginners and experienced SAS users.
Provides a comprehensive overview of SAS Visual Analytics, a web-based tool for data visualization. It covers a wide range of topics, from data exploration to data visualization. It valuable resource for both beginners and experienced SAS users.
Provides a comprehensive overview of SAS Studio, a web-based environment for data analysis. It covers a wide range of topics, from basic data manipulation to advanced statistical analysis. It valuable resource for both beginners and experienced SAS users.
Concise and accessible introduction to SAS programming. It covers the basics of SAS, including data manipulation, analysis, and reporting. It good choice for beginners who want to quickly get up to speed with SAS.

Share

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

Similar courses

Similar courses are unavailable at this time. Please try again later.
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 - 2025 OpenCourser