Data Analytics SAS Training in Bangalore

SAS Course Content

Our SAS Course content is structured to cover all the modules within SAS. From basic to advance, we give SAS training in Bangalore in a manner that is easy to understand.

Below is the detailed course content for SAS Training

Introduction to SAS and Basic concepts (Part 1)

• What is SAS System?
• An Overview of the SAS System

Working in the SAS Environment

• Use the five main SAS windows: the Explorer, Program Editor, Log, Output, and Results windows
• Use Enhanced Editor windows
• Manage your SAS windows
• Create SAS libraries
• Explore and manage SAS files
• Enter and submit SAS programs
• Create and use file shortcuts

Basic Concepts

• The structure and components of SAS programs
• The steps involved in processing SAS programs
• The structure and components of SAS data sets
• Temporary and permanent SAS libraries
• Reading the SAS Log
• Using SAS System Options

Getting Your Data into SAS (Part 2)

Reading Raw Data

• Reference a SAS data library
• Reference a raw data file
• Name a SAS data set to be created
• Specify a raw data file to be read
• Read standard character and numeric values in fixed fields
• Submit and verify a data step program
• Subset data.

Reading Raw Data in Fixed Fields

• Distinguish between standard and nonstandard numeric data
• Read standard fixed-field data
• Read nonstandard fixed-field data

Reading Free-Format Data

• Free-format data, or data that is not organized in fixed fields
• Free-format data separated by nonblank delimiters, such as commas
• Free-format data that contains missing values
• Character values that exceed eight characters
• Nonstandard free-format data
• Character values that contain embedded blanks
• Controlling input with options in the infile statement.

Reading Date and Time Values

• How SAS software stores date and time values
• To read common date and time expressions using SAS informats
• How to handle two-digit date values

Creating a Single Observation from Multiple Records

• Read multiple records in a sequential order and create a single observation
• Read multiple records in any order to create a single observation.

Creating Multiple Observations from a Single Record

• Create multiple observations from a single record that contains repeating blocks of data
• Hold the current record across iterations of the data step
• Hold the current record for the next input statement
• Execute sas statements based on a variable’s value
• Explicitly write an observation to a data set
• Execute sas statements while a condition is true.

Working with Your SAS Data (Part 3)

Understanding DATA Step Processing

• Identify the two phases that occur when a DATA step is processed
• Identify the processing phase in which an error occurs
• Debug SAS DATA steps.

Reading, Concatenating and Merging SAS Data Sets

• Create a new data set from one or more existing data sets
• Select observations based on a condition
• Select variables to include or exclude
• Using if-then statements
• Grouping observations with if-then/else statements
• Sub-setting your data
• Selected date informats, functions, and formats
• Using the retain and sum statements
• Using shortcuts for lists of variable names
• Using sas data set options
• Tracking and selecting observations with the in= option
• Writing multiple data sets using the output statement
• Making several observations from one using the output statement
• Using sas automatic variable (_n_ , _error_,)

Transforming Data with SAS Functions

• Convert character data to numeric data
• Convert numeric data to character data
• Create sas date values
• Extract the month and year from a sas date value
• Extract, edit, and search character variable values.

Debugging and Testing DATA Steps

• How SAS processes a DATA step
• How to debug a DATA step
• How to test your programs.

Generating Data with DO Loops

• Construct a DO loop to perform repetitive calculations
• Control the execution of a DO loop
• Generate multiple observations in one iteration of the DATA step
• Construct nested DO loops.

Processing Variables with Arrays

• Group variables into one- and two-dimensional arrays
• Perform an action on array elements
• Create new variables using an array statement
• Assign initial values to array elements
• Create temporary array elements using an array statement

Editing and Debugging SAS Programs

• Include a stored SAS program
• Edit SAS programs
• Clear SAS programming windows
• Interpret error messages in the SAS log
• Correct errors
• Resolve common problems.

Using SAS procedures (Part 4)

Creating List Reports

• Specify SAS data sets to print
• Select variables and observations to print
• Specify column totals for numeric variables
• Sort data by values of one or more variables
• Assign descriptive labels to variables
• Double space SAS listing output.

Creating Tabular Reports

• The variables to appear in your table
• The statistic to be computed for each variable
• The arrangement of statistics and variables in the table
• Additional features such as formats for values in the table, column and row totals, and labels for statistics and a summary variable
• Creating Plots
• Creating Bar and Pie Charts
• Enhancing Reports
• Enhancing and Exporting Charts and Plots
• Enhancing and Exporting Charts and Plots
• Enhancing Your Output with ODS
• Creating SAS Data Sets from Procedure Output
• Using ODS Statements to Create HTML
• Using ODS Statements to Create RTF, PDF

SAS procedures

• APPEND Procedure
• COMPARE Procedure
• CONTENTS Procedure
• DATASETS Procedure
• EXPORT Procedure
• FORMAT Procedure
• FREQ Procedure
• IMPORT Procedure
• MEANS Procedure
• PLOT Procedure
• PRINT Procedure
• PRINTTO Procedure
• REPORT Procedure
• SORT Procedure
• SUMMARY Procedure
• TABULATE Procedure
• TRANSPOSE Procedure
• UNIVARIATE Procedure

ADVANCED SAS

SAS / Macros Part 1

Understanding the Concepts and Features of Macro Programming

• What Is the SAS Macro Facility?
• What Are the Advantages of the SAS Macro Facility?
• Where Can the SAS Macro Facility Be Used?
• Examples of the SAS Macro Facility

Mechanics of Macro Processing

• SAS Processing without Macro Activity
• Comparing Macro Language Processing and SAS Language Processing
• Processing a SAS Program That Contains Macro Language

Macro Variables

• Basic Concepts of Macro Variables
• Referencing Macro Variables
• Understanding Macro Variable Resolution and the Use of Single and Double Quotation Marks
• Displaying Macro Variable Values
• Understanding Automatic Macro Variables
• Understanding User-Defined Macro Variables
• Combining Macro Variables with Text
• Referencing Macro Variables Indirectly

Macro Programs

• Creating Macro Programs
• Executing a Macro Program
• Displaying Notes about Macro Program Compilation in the SAS Log
• Displaying Messages about Macro Program Processing in the SAS Log
• Passing Values to a Macro Program through Macro Parameters

Understanding Macro Symbol Tables and the

• Processing of Macro Programs
• Understanding Macro Symbol Tables
• Processing of Macro Programs

Macro Language Functions

• Macro Character Functions
• Macro Evaluation Functions
• Macro Quoting Functions

Macro Expressions and Macro Programming Statements

• Constructing Macro Expressions
• Conditional Processing with the Macro Language
• Iterative Processing with the Macro Language
• Branching in Macro Processing
• Masking Special Characters and Mnemonic Operators
• Illustrating the Need for Macro Quoting Functions
• Describing the Commonly Used Macro Quoting Functions

Part 2 Applying Your Knowledge of Macro Programming

• Storing and Reusing Macro Programs
• Debugging Macro Programming
• Understanding the Types of Errors That Can Occur in Macro Programming
• Examples of Solving Errors in Macro Programming

A Stepwise Method for Writing Macro Programs

• Building a Macro Program in Four Steps
• Applying the Four Steps to an Example

SAS / SQL Introduction to the SQL Procedure

• What Is SQL?
• What Is the SQL Procedure?
• Terminology
• Comparing PROC SQL with the SAS DATA Step

Retrieving Data from a Single Table

• Overview of the SELECT Statement
• Selecting Columns in a Table
• Creating New Columns
• Sorting Data
• Retrieving Rows That Satisfy a Condition
• Summarizing Data
• Grouping Data
• Filtering Grouped Data
• Validating a Query

Creating and Updating Tables

• Creating Tables
• Inserting Rows into Tables
• Updating Data Values in a Table
• Deleting Rows
• Altering Columns
• Deleting a Table
• Using SQL Procedure Tables in SAS Software
• Using PROC SQL with the SAS Macro Facility
• Creating and Using Macro Variables in SQL

Best SAS Training institute in Bangalore

• Trained over 2000 students
• Over a Decade of experience in Training industry
• Experienced and Certified trainers
• Practical and Theory training
• Flexible Batch timings