Introduction

• The SAS programming process.

• Submitting a SAS program

• Using SAS programming tools.

• Understanding SAS syntax.

• Diagnosing and correcting syntax errors

• Mastering fundamental concepts

Accessing Data

• Understanding SAS data.

• Accessing data through libraries.

• Importing data into SAS.

Exploring and Validating Data

• Exploring data.

• Filtering rows.

• Formatting columns.

• Sorting data and removing duplicates.

Preparing Data

• Reading and filtering data.

• Computing new columns.

• Conditional processing.

Analyzing and Reporting on Data

• Enhancing reports with titles, footnotes, and labels.

• Creating frequency reports.

• Creating summary statistics reports.

Exporting Results

• Exporting data.

• Exporting reports.

Using SQL in SAS

• Using Structured Query Language in SAS.

• Joining tables using SQL in SAS.

Controlling DATA Step Processing

• setting up for this course

• understanding DATA step processing

• directing DATA step output

Summarizing Data

• creating an accumulating column

• processing data in groups

Manipulating Data with Functions

• understanding SAS functions and CALL routines

• using numeric and date functions

• using character functions

• using special functions to convert column type

Creating Custom Formats

• creating and using custom formats

• creating custom formats from tables

Combining Tables

• concatenating tables

• merging tables

• identifying matching and nonmatching rows

Processing Repetitive Code

• using iterative DO loops

• using conditional DO loops

Restructuring Tables

• restructuring data with the DATA step

• restructuring data with the TRANSPOSE procedure

Placement Guide

• What is an Interview

• Tips to clear an Interview

• Common Interview questions and answers

• SAS Interview Questions and Answers

• Resume Building Guide

• Career roadmap and certifications

• Attempt for related Global Certification Exam

• Start applying for Jobs