SAS

Faculty – Professional Snapshot
Our Faculty is SAS Certified with more than 8+ years experience in classroom, Online, trainings and approx. 9+ years of experience in Retail, health care and banking domain on Customer Driven Relevance Marketing (Direct Customer Mailing Campaigns, Campaign’s Performance Evaluation) along with Customer Targeting, Retention & Acquisition.
Worked on multidisciplinary projects related to campaign management, building a solution from scratch, automations, revamping of codes.
Experience of project management, providing business insights and direction to project team and managing client relationship.
Define, design and deliver DataStage ETL development work and packages that adhere to standards, guidelines, quality assurance reviews and testing.

Why SAS-
SAS uses in different domains mainly in Clinical, Telecom, Finance, Market Research, Insurance, Banking etc. SAS ranks No. 2 on 2014 Fortune list of Best Companies to Work For-
On the list yearly since its 1998 inception, SAS attracts and keeps creative employees because doing so directly contributes to consistent revenue growth, profitability and industry-leading products and solutions. SAS CEO Jim Goodnight firmly believes that happy employees create happy customers. Why Analytics-
It’s common knowledge that Analytics/Data Mining/Data Science is among the most sought after skills today. There is a huge demand for Analytics Professionals/Data Scientists globally in almost every possible sector-Financial Services, Retail, FMCG/CPG, Telecom, Technology, Supply Chain, Social Sciences, spatial sciences, bioinformatics, health care etc. Analytics for Indian businesses –
Indian businesses have also understood the power of analytics. It started with the financial services companies like ICICI, HDFC, HSBC etc. and spread to the retail domain with Shoppers Stop, Pantaloons and many others. Slowly but steadily, the demand for analytics professionals is growing in the Indian businesses as well.

SAS Syllabus
TECHNICAL
BASE SAS
Introduction to SAS Programming
Working in the SAS Environment
• Introduction
Working with the windows
• Enhance editor window
• Log window
• Output window
• Result window
• Explorer window
• Program editor window
Overview of libraries
• Datasets
• Data view
• Catalog
• Referencing Files in SAS Libraries
Basic concepts
• Creating a SAS Programs
• Components of SAS Programs
• Characteristics of SAS Programs
• Layout of SAS Programs
Understanding Data step Processing
• Program data vector(PDV)
• Compilation Phase
• Execution Phase
Options
• Global options
• Local Options
Statements
• Global Statements
• Local Statements
Input Styles
• List input
• Column input
• Formatted input
• Modified input
• Named input
Pointers
• Column pointers
• Line Pointers
Informats and Formats
Informats
• Character informats
• Numeric informats
• Date and time informats
Formats
• Character formats
• Numeric formats
• Date and time formats
Functions
• Arithmetic Functions
• String Functions
• Date and Time Functions
Combining SAS Datasets
• Concatenating
• Merging
• One-to-one merging
• One-to-many merging
• Many-to-one merging
• Many-to-many merging
• Matching merging
• Interleaving
• Updating
Control Statements
• If statement and if else statement
• If then else statement
• Where statement
• Loops (do, do until, do while)
• Arrays statement
Reading Raw Data from External File
• Infile statement
• Filename statement
Writing Data to External Files
• File Statement
• Put Statement
Output Delivery System (ODS)
• Fundamentals of the ODS
• ODS and the Data step
• Syntax for ODS Enhanced features in a Data step
• Introduction to ODS language Statements
• Dictionary of ODS language Statements
Procedures
• Proc Print Proc Transpose
• Proc Sort Proc Forms
• Proc Contents Proc Formats
• Proc Append Proc Tabulate
• Proc Import Proc Report
• Proc Export Proc Printto
• Proc Copy Proc Datasets
• Proc Access Proc Means
• Proc Freq Proc Rank
SAS/GRAPH
• Introduction to Graphs
• Types of Graphs
▪ Chart
▪ Plot
▪ Illustration of axis options
▪ Illustration of symbol options
▪ Illustration of footnote, note, title
▪ Graph n go
FUNCTIONAL
SAS/STAT
▪ Introduction to Statistics
▪ Producing Descriptive Statistics
▪ Computing Statistics for Numeric Variables
Procedures
▪ Proc Means
▪ Proc Summary
▪ Proc Univariate
▪ Proc Freq etc.
ADVANCED SAS
SAS/MACROS
• Introduction to Macro Language Elements
• Introduction to Macro Variables
▪ Automatic Macro Variables
▪ User defined Macro Variables
• Introduction to Macro Processing
• Macro Statements
• Macro Functions
SAS/SQL
• Introduction to Proc SQL
• Creating tables
• Inserting data into tables
• Alter the tables & etc…
• Update
• Modifying the tables
Retrieving Data from Single Table
• Integration of Database
• Connecting to a DBMS Using the SQL Procedure Pass-Through Facility
• Connecting to a excel Using the SQL Procedure Pass-Through Facility
• Connecting to a access Using the SQL Procedure Pass-Through Facility
• Connecting to a DBMS Using the Libname Statement
Retrieving Data from Multiple tables
• Natural Join
• Inner Join
• Outer Join (Right, Left, Full)
SAS/ACCESS
• Define SAS/Access Software
• Identify the types of data repositories that SAS/Access can access
• The interface engine
• The SAS/Access Libname Statement
• The SQL Procedure Pass-Through Facility
• The Access Procedure
• Requirements to Connect to a Database
• SAS/Access Libname engines
Note: Training includes:
Book – SAS by Examples (Soft copy), Little SAS Book (Soft copy)
Power point presentations – Based on Lectures with full of explanations and examples.
Industries based example and Case Studies.
Interview Preparation.
Assessments.
2 Mock interviews.
Resume designing.
Project (Optional).
Thanks and Regards,
Analytical EduPoint