SAS Training in Pune

SAS Training in Pune - ETLHIVE

Get Updates on Demo session,Syllabus and timings by filling up this form

Your Name (required)

Your Email (required)

Mobile number(Prefix "+91-")

Branch

Course

New Batches

Type Demo Session New Batch Location
Weekend 1-Sep-2018 12PM 2-Sep-2018 Pimple Saudagar
Weekend 1-Sep-2018 12PM 2-Sep-2018 Nal Stop
Weekend 1-Sep-2018 12PM 2-Sep-2018 Kharadi

   
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.

Our Courses


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
  • SAS System Options – OBS, FIRSTOBS, BUFNO, BUFSIZE
  • SAS System Options – LINESIZE, PAGESIZE, NODATE, YEARCUTOFF
  • 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
  • SAS Functions: UPCASE, LOWCASE, MEAN, COMPRESS, LENGTH

 

 

 

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
  • PROC Means, CORR, FREQ, UNIVARIATE, REG, ANOVA
  • Defining Clustering
  • Exploring Clustering Methodologies
  • K Means Clustering
  • Decision Tree
  • Regression and Logistic Regression
  • Time Series Analysis
  • White Noise Process
  • ARIMA Modeling
  • Optimization Models
  • PROC OPTMODEL


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!

                                         

                                         

   More

"What our customers say"

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

                               Google-Reviews

Justdial-Pimple Sudagar

etlhive-sulekha-pimplesaudagar

etlhive-yet5-pimple saudagar

top
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.
18th Aug - Demo Session - P.Saudagar - Hadoop : 12.00 pm | Data science : 12.00 pm | Hadoop Admin : 10.15 am | AB Initio :12.00 pm | Informatica : 1.30 pm | Tableau : 5.00 pm | Salesforce : 2.00 pm | blueprism : 3.30 pm | Digital Marketing : 12.00 pm (Sun) | Nal Stop - Angular JS : 11.15 am | Hadoop : 11.00 am | Python : 4.00 pm | Kharadi - Selenium : 3.00 pm | Hadoop : 1.00 pm | Tableau : 10.30 am | Navi Mumbai - AWS : 11.00 am | Data Science : 1.00 pm | Hadoop : 3.00 pm | Java : 5.00 pm | Devops : 1.00 pm | Selenium : 4.00 pm | Python : 2.00 pm