SAS Training in Pune

SAS Training in Pune - ETLHIVE

SAS Training in Pune

About the Course

ETLhive delivers globally recognized training sessions on SAS with an overall exploration of the data science domain. SAS training course at ETLhive explains in detail about the role of data scientists and how they use SAS and other tools, statistics, and data manipulation techniques to make best of the available data. As such, Data Analytics is one of the most popular domains and it is growing by leaps and bounds. Every company relies on data for its growth and that is the primary reason why these companies are looking for smart data scientists and analysts. During the SAS training course, you will have hands-on experience on various SAS functions and other important concepts such as PROC SQL, PROC, PROC UNIVARIATE, PROC MEANS, PROC FREQ, PROC CORP, and more. You will also undergo full-fledged training on SAS Macros, Regression, Clustering, and Data Manipulation. As a matter of fact, Data Manipulation is centric to SAS therefore there will be practical sessions on the same, followed by Resume and Interview preparation rounds. 

Intended Audience for SAS Training Course

  • IT professionals who wish to switch in the field of data analytics
  • Analytics professionals keen to work in SAS
  • Software Developers interested in data analytics
  • Fresh graduates who wish to make a career in data analytics

 Prerequisites for SAS

There are no technical prerequisites for this course. However, knowledge of statistics will prove beneficial.

SAS Course Content


SAS Fundamentals

  • Defining SAS
  • Advantages of SAS
  • Studying the Components of SAS
  • Understanding SAS Windows
  • Navigating in SAS Console
  • SAS Language Input Files
  • Data Step Processing
  • Data Sets
  • Combining and Modifying Datasets
  • Concatenating Datasets
  • Interleaving Methods

Data Manipulation in SAS

  • Reading Raw Data Files: COLUMN
  • Reading Raw Data Files: FORMATTED
  • Reading Raw Data Files: LIST
  • Controlling Processing of Data with INFILE Statement
  • Exploring Components of INPUT Statement
  • Column, Line Pointer, Trailing @ Controls
  • Exploring SAS Libraries
  • Temporary and Permanent Libraries
  • Reading Data with Missover, Truncover
  • Reading Data with Stopover, Flowover
  • Reading Data with DSD and DLM
  • DATA Step Processing
  • Phases: Compilation and Execution
  • Understanding Program Data Vector (PDV)
  • SAS Data Sets and Descriptor Portions
  • Storage of SAS Files


SAS Statements

  • System Options
  • Data Set Options
  • Statement Options
  • Informats and Formats
  • SAS Statements: Attrib and Datalines
  • SAS Statements: Delete, Drop, and Keep
  • SAS Statements: Label, Length, Retain, Sum, and Dim

SAS Options and Functions

  • Studying Data Set Options
  • Data Set Options: KEEP, DROP, RENAME, FIRSTOBS
  • Data Set Options: OBS, IN, LABEL, WHERE
  • Exploring SAS System Options
  • Understanding SAS Functions
  • SAS Functions: INPUT and PUT
  • SAS Functions for Date and Time: MONTH, YEAR, DAY
  • SAS Functions for Date and Time: MDY, DATE, TODAY, DATETIME
  • SAS Functions: SCAN, SUBSTR, TRIM
  • SAS Functions: LEFT, RIGHT, INDEX




Arrays and Conditional Processing

  • Understanding Arrays
  • How to Create Variables using Arrays?
  • How to Assign Initial Values to Arrays?
  • Exploring Multidimensional Array
  • Understanding Conditional Processing
  • Subsetting IF
  • IF-THEN/ELSE Statement
  • Implementing DO statement
  • Nesting of the DO Loop
  • DO UNTIL and DO WHILE Statement




Data Manipulation

  • Exporting Data
  • Creating Standard and Comma-delimited Raw Data Files
  • Connecting to Servers
  • Connecting to SQL Server
  • FTP through SAS
  • Merging and Appending Data
  • Exploring SET and MERGE Statements
  • Studying MODIFY and UPDATE Statements
  • Implementing WHERE Statement
  • Difference between WHERE and IF Statements
  • RETAIN and RETURN Statements
  • SAS Procedures: Analysis and Report Generation
  • Defining PROC SQL
  • Proc Print and Proc Sort
  • Proc Means and Proc Contents
  • User-defined Formats
  • User-defined Titles
  • User-defined Footnotes
  • Retrieving Data from a Table
  • Selecting Columns in a Table
  • Retrieving Data from Multiple Tables
  • Selecting Data from Multiple Tables
  • Concatenating Query Results
  • Date/Time Functions
  • Missing Value Treatment
  • Handling Missing Value
  • SCAN Function




SAS Macros and Techniques

  • Understanding SAS Macros
  • Need for SAS Macros
  • Storing SAS Macros
  • SAS Macros Functions
  • SQL Clauses for SAS Macros
  • Calling Macros
  • Understanding Macros Variables
  • What are Macro Parameters?
  • Macro Quoting Techniques
  • Studying Macro Debugging Technique
  • The % Macro Statement
  • The Conditional Statement
  • Error Handling in SAS
  • Programming Logic Errors
  • Identifying and Resolving Errors
  • Recognizing and Correcting Syntax Errors

Statistics and Statistical Procedures

  • Statistics and Statistical Terms
  • Procedures in SAS for Descriptive Statistics
  • Hypothesis Testing
  • Parametric and Non-Parametric Tests
  • Parametric Tests – Advantages and Disadvantages
  • Statistical Procedures
  • Defining Clustering
  • Exploring Clustering Methodologies
  • K Means Clustering
  • Decision Tree
  • Regression and Logistic Regression
  • Time Series Analysis
  • White Noise Process
  • ARIMA Modeling
  • Optimization Models

New Batches

Type Demo Session New Batch Location
Weekend 2-Mar-2018 2.00 PM 3-Mar-2018 Pimple Saudagar
Weekend 2-Mar-2018 1.00 PM 3-Mar-2018 Nal Stop
Weekend 2-Mar-2018 4.00 pm 3-Mar-2018 Kharadi

SAS Course Features



One Stop Solution!

   Ability to attend missed sessions

    Complete documentation

   Resume preparation

   Certification preparation.

   Interview preparation

   Placement assistance

We Deliver What We Promise!




"What our customers say"

Social Reviews- (72 Votes, Average:-4.5 out of 5)


Justdial-Pimple Sudagar


etlhive-yet5-pimple saudagar

ETLHIVE is a Trademark of Itelligence Infotech Pvt Ltd.   *PMP®, PMBOK, PMI, PgMP, CAPM, PMI-RMP, and PMI-ACP are registered trademarks of the Project Management Institute, Inc. *ITIL®, IT Infrastructure Library, Swirl Logo, Prince2 are registered trademarks of AXELOS Limited.
Demo Session 16th Feb – P.Saudagar – Hadoop : 12.00 pm | Data Science : 12.00 pm | Python : 12.00 pm | Salesforce : 2.00 pm | Angular JS : 11.30 am | Digital Marketing : 10.00 am | Nal Stop - Python : 1.30 pm | Digital Marketing : 2.00 pm | Data Science : 2.00 pm (Sun) | Selenium : 4.00 pm | AWS : 12.00 pm | Kharadi - Data Science : 3.00 pm | Tableau : 11.00 am | Digital Marketing : 5.00 pm | Vashi - AWS : 11.00 am | DevOps : 12.00 pm | Data Science : 3.30 pm | Hadoop : 12.30 pm | Selenium : 5.00 pm