Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.

SAS for Data Analysis

  • Course Code: Data Analysis / BI - SAS for Data Analysis
  • Course Dates: Contact us to schedule.
  • Course Category: Big Data & Data Science Duration: 3 Days Audience: This course is geared for Python experienced developers, analysts or others who wants to get Leverage the full potential of SAS to get unique, actionable insights from your data.

Course Snapshot 

  • Duration: 3 days 
  • Skill-level: Foundation-level SAS for Data Analysis skills for Intermediate skilled team members. This is not a basic class. 
  • Targeted Audience: This course is geared for Python experienced developers, analysts or others who wants to get Leverage the full potential of SAS to get unique, actionable insights from your data.  
  • Hands-on Learning: This course is approximately 50% hands-on lab to 50% lecture ratio, combining engaging lecture, demos, group activities and discussions with machine-based student labs and exercises. Student machines are required. 
  • Delivery Format: This course is available for onsite private classroom presentation, or remote instructor led delivery, or CBT/WBT (by request). 
  • Customizable: This course may be tailored to target your specific training skills objectives, tools of choice and learning goals. 

SAS is one of the leading enterprise tools in the world today when it comes to data management and analysis. It enables the fast and easy processing of data and helps you gain valuable business insights for effective decision-making. This course will serve as a comprehensive guide that will prepare you for the SAS certification exam. After a quick overview of the SAS architecture and components, the course will take you through the different approaches to importing and reading data from different sources using SAS. You will then cover SAS Base and 4GL, understanding data management and analysis, along with exploring SAS functions for data manipulation and transformation. Next, you’ll discover SQL procedures and get up to speed on creating and validating queries. In the concluding lessons, you’ll learn all about data visualization, right from creating bar charts and sample geographic maps through to assigning patterns and formats. In addition to this, the course will focus on macro programming and its advanced aspects. By the end of this course, you will be well versed in SAS programming and have the skills you need to easily handle and manage your data-related problems in SAS. 

Working in a hands-on learning environment, led by our SAS for Data Analysis expert instructor, students will learn about and explore: 

  • Build enterprise-class data solutions using SAS and become well-versed in SAS programming 
  • Work with different data structures, and run SQL queries to manipulate your data 
  • Explore essential concepts and techniques with practical examples to confidently pass the SAS certification exam 

Topics Covered: This is a high-level list of topics covered in this course. Please see the detailed Agenda below 

  • Explore a variety of SAS modules and packages for efficient data analysis 
  • Use SAS 4GL functions to manipulate, merge, sort, and transform data 
  • Gain useful insights into advanced PROC SQL options in SAS to interact with data 
  • Get to grips with SAS Macro and define your own macros to share data 
  • Discover the different graphical libraries to shape and visualize data with 
  • Apply the SAS Output Delivery System to prepare detailed reports 

Audience & Pre-Requisites 

This course is geared for attendees with Python skills who wish to get Leverage of full potential of SAS to get unique, actionable insights from your data 

Pre-Requisites:  Students should have  

  • developers with some knowledge of Python.  
  • experienced with spreadsheet software who know the basics of Python. 

Course Agenda / Topics 

  1. Introduction to SAS Programming 
  • Introduction to SAS Programming 
  • SAS dataset fundamentals 
  • SAS programming language – basic syntax 
  • SAS LOG 
  • Dataset options 
  • SAS operators 
  • Formats 
  • Subsetting datasets 
  • Dictionary tables 
  1. Data Manipulation and Transformation 
  • Data Manipulation and Transformation 
  • Length of a variable 
  • Case conversion and alignment 
  • String identification 
  • Dealing with blanks 
  • Missing and multiple values 
  • Interval calculations 
  • Concatenation 
  • Logic and control 
  • Number manipulation 
  1. Combining, Indexing, Encryption, and Compression Techniques Simplified 
  • Combining, Indexing, Encryption, and Compression Techniques Simplified 
  • Introduction to combining 
  • Concatenation 
  • Interleaving 
  • Merging 
  • Indexing 
  • Encryption 
  1. Power of Statistics, Reporting, Transforming Procedures, and Functions 
  • Power of Statistics, Reporting, Transforming Procedures, and Functions 
  • Proc Freq 
  • Proc Univariate 
  • Proc Means and Summary 
  • Proc Corr 
  • Proc REG 
  • Proc Transpose 
  1. Advanced Programming Techniques – SAS Macros 
  • Advanced Programming Techniques – SAS Macros 
  • What are macros? 
  • Macro variable processing 
  • Macro resolution tracking 
  • Macro definition processing 
  • Comparing positional and keywords parameters 
  • Data-driven programming 
  • Leveraging automatic global macro variables 
  • Macros that evaluate 
  • Writing efficient macros 
  1. Powerful Functions, Options, and Automatic Variables Simplified 
  • Powerful Functions, Options, and Automatic Variables Simplified 
  • NOMPREPLACE and MREPLACE 
  • NOMCOMPILE and NCOMPILE 
  • MCOMPILENOTE 
  • NOMEXECNOTE and MEXECNOTE 
  • MAUTOCOMPLOC 
  • MACRO and NOMACRO 
  • Exchanging values between the DATA step and macro variables 
  • CALL EXECUTE 
  • Altering the CALL SYMPUT example 
  • Resolving macro variables 
  • Macro quoting 
  1. Advanced Programming Techniques Using PROC SQL 
  • Advanced Programming Techniques Using PROC SQL 
  • Comparing data steps and Proc SQL 
  • Proc SQL joins 
  • Proc SQL essentials 
  • Dictionary tables 
  1. Deep Dive into PROC SQL 
  • Deep Dive into PROC SQL 
  • SAS views in Proc SQL 
  • Making changes with Proc SQL 
  • Identifying duplicates using Proc SQL 
  • Creating an index in Proc SQL 
  • Macros and Proc SQL 
  1. Data Visualization 
  • Data Visualization 
  • The role of data visualization in analytics 
  • Histograms 
  • Line plots 
  • Vertical and horizontal bar charts 
  • Scatter charts 
  • Box plot 
  1. Reporting and Output Delivery System 
  • Reporting and Output Delivery System 
  • Proc Tabulate 
  • Specifying the ODS destination 
  • Formatting ODS files 
  • ODS Excel charts 
View All Courses

    Course Inquiry

    Fill in the details below and we will get back to you as quickly as we can.

    Interested in any of these related courses?