SAS is an integrated system of software solutions that enables you to perform the following tasks:

• Data entry, Retrieval, and management
• Report writing and graphics design
• Statistical and mathematical analysis
• Business forecasting and decision support
• Operations research and project management
• Applications development.

Anybody who is working in the data must know SAS to grow in their career and first step towards this is always a certification and fundamental knowledge of language. Hence we brings you a Hands On SAS( Base and Advance) Training which will help you not only for your SAS certification, but even make you master in SAS Programming. Once you do or complete all the hands on session by your own given in our training you will become very comfortable in SAS programming.

Business Intelligence professionals

Software developers and architects

Project managers

ETL, SQL, data warehouse and analytics professionals

Mainframe and testing professionals

Graduates wanting to enter Big Data analytics

Any Graduate from any stream can learn SAS and get trained , Having a basic knowledge of SQL can help.
As part of this Base SAS Certification training you will be working on projects and assignments that have immense implications in the real world industry scenario thus helping you fast track your career effortlessly.

Introduction to SAS

Introduction to Base SAS, Installation of SAS tool, Getting started with SAS, various SAS Windows – Log, Explorer, Output, Search, Editor, etc. working with data sets, overview of SAS Functions, Library Types and programming files

Hands-on Exercise – Import Excel,CSV,TEXT files in workspace, Read data, Export the workspace to save data

SAS Operators & Functions

Various SAS Operators – Arithmetic, Logical, Comparison, various SAS Functions – NUMERIC, CHARACTER, IS NULL, CONTAINS, LIKE, Input/Put, Date/Time, Conditional Statements (Do While, Do Until, If, Else)

Hands-on Exercise- Apply logical, arithmetic operators and SAS functions to perform operations

Compilation & Execution

Understanding about Input Buffer, PDV (Backend), learning what is Missover

Using Variables

Defining and Using KEEP and DROP statements, apply these statements, Format and Labels in SAS.

Hands-on Exercise- Use KEEP and DROP statements

Creation and Compilation of SAS Data sets

Understanding Delimiter, dataline rules, DLM, Delimiter DSD, raw data files and execution, list input for standard data.

Hands-on Exercise-

Use delimiter rules on raw data files

SAS Procedures

The various SAS standard Procedures built-in for popular programs – PROC SORT, PROC FREQ, PROC SUMMARY, PROC IMPORT, PROC EXPORT, PROC DATASETS, PROC TRANSPOSE, PROC MEANS, PROC FORMAT, PROC COMPARE etc.

Hands-on Exercise- Use SORT, FREQ, SUMMARY, MEANS and other procedures

Input statement and formatted input

Reading standard and non-standard numeric inputs with Formatted inputs, Column Pointer Controls, Controlling while a record loads, Line pointer control / Absolute line pointer control, Single Trailing , Multiple IN and OUT statements, DATA LINES statement and rules, List Input Method, comparing Single Trailing and Double Trailing

Hands-on Exercise- Read standard and non-standard numeric inputs with Formatted inputs, Control while a record loads, Control a Line pointer, Write Multiple IN and OUT statements

SAS Graphs

Understanding PROC GCHART, various Graphs, Bar Charts – Pie, Bar, 3D, plotting variables with PROC GPLOT

Hands-on Exercise- Plot graphs using PROC GPLOT Display charts using PROC GCHART

Interactive Data Processing

SAS advanced data discovery and visualization, point-and-click analytics capabilities, powerful reporting tools.

Data Transformation Function

Character Functions, Numeric Functions, Converting Variable Type

Hands-on Exercise- Use Functions in data transformation

Output Delivery System (ODS)

Introduction to ODS, Data Optimization, How to generate files (rtf, pdf, html, doc) using SAS

Hands-on Exercise-Optimize data, generate rtf, pdf, html and doc files

SAS MACROS

Syntax, Macro Variables, Positional Parameters, Keyword Parameters, Macro String Functions, in a Macro, Macro Step, Macro interface Functions, Stored Macros.

Hands-on Exercise-Write a macro, Use positional parameters and Keyword Parameter.

PROC SQL

SQL Statements in SAS, SELECT, CASE, JOIN, UNION, Sorting Data

Hands-on Exercise-Create sql query to select and add a condition Use a CASE in select query

Summarization Reports

Report Enhancement, Global Statements, User-defined Formats, PROC SORT, ODS Destinations, ODS Listing, PROC FREQ, PROC Means, PROC UNIVARIATE, PROC REPORT, PROC PRINT

Hands-on Exercise-Use PROC SORT to sort the results, List ODS, Find mean using PROC Means, print using PROC PRINT