BASE SAS CERTIFICATION
& ADVANCE SAS
Why Should You Take
Base SAS Certification
& Advance SAS
Base SAS course is entry level program for candidates those looking career in analytics. In this course you can learn how to write SAS programs and build logics to develop the solution for handling different type of client requirement. This course enhance knowledge and programming skills as a professional SAS programmer. During the training, provided daily practice assignments help candidate to get fare idea about how to write the code to develop high quality reports.
Instructor Led SAS Live Training
Apply For New Batches
INTRODUCTION:
-
Introduction of SAS software.
-
Industries using SAS
-
Components of SAS System.
-
Architecture of SAS system.
-
Functionality of SAS System.
-
Introduction of SAS windows
CREATING AND REDEFINING VARIABLE:
-
Use with different conditional statements.
DEBUGGING ERROR MESSAGE:
-
DEBUGGING syntax ERROR MESSAGES
COMBINATION THE DATASET:
-
One-o-one reading
-
One to many
-
Many to many
-
Concatenation
-
Interleaving,
-
Match merge
FUNCTIONS:
-
Character function
-
Numerical function
-
Arithmetical function
-
Mathematical function
-
Date Function
WORKING IN THE SAS ENVIRONMENT:
-
Functionality of SAS Windows.
-
Creating and managing SAS Libraries.
-
Overview of SAS Data states.
-
Types of Libraries.
-
Storing files temporarily and permanently.
-
Referencing SAS files.
AUTOMATIC VARIABLES:
-
Use of automatic variables.
-
Types of automatics variables.
-
Use of _N_, _ERROR_, _NULL_.
-
Testing your programs.
-
Using put statement.
-
Automatic Variable.
ARRAY:
-
Definition of array
-
Example of array
PROCEDURE IN SAS:
-
Procedure Format.
-
Procedure Contents.
-
Procedure Options.
-
Procedure Append.
-
Procedure Compare.
-
Procedure Transpose.
-
Procedure Print.
-
Procedure Import.
-
Procedure Export.
-
Procedure Datasets.
-
Procedure Rank
-
Procedure Tabulate.
-
Procedure Chart, Gchart, Gplot.
-
Procedure Report.
CREATING DATABASE FROM RAW DATA:
-
Steps to create a SAS dataset.
-
Creating SAS dataset using text file.
-
Creating SAS dataset using text file with delimiters.
-
Creating SAS dataset using structured text file.
-
Creating SAS dataset using unstructured text file.
-
Creating SAS dataset using Excel file.
-
Creating SAS dataset using Access file.
-
Creating SAS dataset using values inside the code.
OUTPUT DELIVERY SYSTEM:
-
Concepts of output delivery system.
-
How ODS works and viewing output of ODS in different format.
-
HTML, RTF, PDF etc..
SAMPLING METHOD:
-
Random sampling
-
Loops in SAS: Do Loops
-
Loops are used to iterate through every observation for specified number of times to obtain a desired result
Loops in SAS: Do Loops
-
Do Loop
-
Do While
-
Do Until
ADVANCE SAS TOPICS:
ADVANCE PROGRAMMING –
PROC SQL:
-
Performing Queries Using PROC SQL
-
Performing Advanced Queries Using PROC SQL
-
Combining Tables Horizontally Using PROC SQL
-
Combining Tables Vertically Using PROC SQL
-
Creating and Managing Tables Using PROC SQL
-
Creating and Managing Indexes Using PROC SQL
ADVANCE PROGRAMMING – MACRO:
-
Introduction to Macros.
-
Defining Macro facility.
-
Generating SAS code using Macros.
-
Placing text using Macro variable.
-
Passing Macro Elements.
-
Macro Execution Process.
-
Macro Statements.
GRAPHS:
-
Introduction to graphics.
-
Introduction to graphics.
-
Types of Graphics (with latest models)
-
Defining procedure Graphics.
SUPPORT
-
Study material: Notes and Books
-
Daily assignments with respect to chapter for hands on experience
-
Interview preparation
-
Resume preparation help