Base SAS Certification Training

1. Introduction and Accessing data

Learning Objectives - This module will introduce you to SAS as a language. It will talk about the minimum set of rules SAS works with, about how to access data in SAS, and more.

Topics -Introduction: History, SAS Windows and it’s contents, SAS Studio on SAS University edition, The SAS language, SASdata sets Parts of a SAS program, Modes for submitting a SAS program, How SAS language works, DATA-STEP’s built-in loop, Program data vector (PDV), Getting your data into SAS, Temporary vs. permanent SAS data sets, Working with data, Creating and redefining variables.

2. Working with Data

Learning Objectives -Once we have created or accessed data in SAS, learn how to then how to work on/with it are thelearnings In this module, we will understand SAS functions (there are more than 400 available, so we will focus on a selected few), and some specialized SAS options.

Topics - Creating and redefining variables revisited, SAS functions: NUMERIC, CHARACTER, Working with SAS dates, DATES, SAS formats, SAS informats, PUT & INPUT, Conditional variable creation.

3. Working with Data : Loops and Advanced topics

Learning Objectives -This module has vast literature. This module will talk about how to work on iterative steps/processes with the help of Loops. It will then talk about some advanced topics on working with data.

Topics -Working with data: LOOPS, DO statement (Loop), DO-UNTIL statement, DO-WHILE statement, Working with data: Advanced topics, Retain & Sum statements,Uni-dimensionalARRAYS, PROC SORT – an introduction, SAS Automatic variables

4. Combining Datasets

Learning Objectives - Real-life work scenarios will require an analyst to work with multiple data sets, requiring integration, vertically or horizontally.This module will help you understand how to combine 2 or more SAS datasets.

Topics -Appending datasets, Using SAS dataset option IN, Appending datasets using IN, Merging datasets, Merging scenarios through Venn diagram, Merging codes for 4 scenarios.

5. SAS Procedures

Learning Objectives -SAS houses in-built procedures or SAS programs helping the user save time in writing customized codes for frequently used programs. This module will formally introduce and familiarize the user through some of the most frequently used PROCs in the industry.

Topics - Using SAS PROCEDURES, PROC IMPORT, PROC DATASETS, PROC CONTENTS, PROC PRINT, PROC FREQ, PROC SORT, PROC FORMAT, PROC SURVEYSELECT, PROC TRANSPOSE, PROC MEANS, PROC SUMMARY, PROC RANK, PROC OPTIONS, PROC EXPORT.

6. Basic stats using SAS

Learning Objectives - SAS is a data management as well as an advanced statistical tool. This module familiarizes learners with elementary statistical procedures around SAS.

Topics - Introductory Statistical PROCs, PROC CORR, PROC UNIVARIATE, PROC FREQ, Summarizing data using PROC MEANS, Merging summary statistics to Parent data.

7. Recap and Case study

Learning Objectives -Learning a programming language without its extensive usage will not be effective. Hence, this module will recap the concepts learnt till module 6, and then cover the case study using toy-datasets mimicking the real-life industry challenges in details.

Topics -Concepts quickly revisited, Accessing data, Working with data, Variable creation, Dataset options, Sorting & Combining data , 3 Best practices when approaching a new dataset, Case study on BFSI data:, Problem statement: Building Customer Analytics Record

8. Debugging and Introduction to Advanced SAS

Learning Objectives -If you cannot debug a code then you do not really know coding. So, this module will focus on some of the common mistakes made by SAS programmers. The module also provides guidelines and best practices for avoiding bugs, or even debugging them.

Topics - Debugging, Writing programs that work, Fixing programs that do not work, Introduction to Advanced SAS - Structured Query Language, Macros.