CHAPTER-1 INTRODUCTION TO SAS: ESSENTIALS

• Introduction To Analytics And Its Scope
• Need For SAS And Its Uses
• Overview Of Base SAS Software, Hands On SAS Version (9.4) SAS University Edition, And Version9.3.
• Installation of SAS University Edition
• Data Management Facility
• Structure of SAS Dataset
• SAS Program
• Programming Language
• Elements Of The SAS Language
• Rules for SAS Statements
• Rules For SAS Names
• Ways To Run SAS Programs

CHAPTER 2: HOW SAS WORKS

• Data Step And Proc Statements
• A Simple Program To Read Raw Data And Produce A Report
• Enhancing The Program
• Comment Statements
• How SAS Works
• Processing A Data Step
• Creating The Input Buffer And The Concept of Program Data Vector
• Writing An Observation To The SAS Data Set
• Four Types Of SAS Libraries
• How To Build User-Defined/Permanent Libraries

CHAPTER 3: HANDLING AND IDENTIFYING ERRORS

• Identify and resolve programming logic errors
• Recognize and correct syntax errors
• Examine and resolve data errors

Chapter 4: CHANGE SHAPE OF SAS DATA SETS

• Sub-setting Observations Using Where Adding Permanent Attributes Drop And Keep Statement
• Create temporary and permanent SAS data sets
• Create and manipulate SAS date values Formats In SAS

CHAPTER 5: READING RAW DATA INTO SAS

• Reading And Generating Excel Files
• SAS Name Literals
• List input to read delimited raw data files

CHAPTER 6: CLEANING AND VALIDATING DATA

• Checking Invalid Values In A SAS Data Set
• Conditional Statements (If-Then/Else)
• Using A Select Group

CHAPTER 7 – MERGING DATA

• Proc Append
• Concatenation
• Proc Sort
• Merging

CHAPTER 8 -GENERATING REPORTS

• Generate list reports using the PRINT procedure
• Generate summary reports (PROC MEANS) and frequency tables using PROC FREQUENCY AND PROC TABULATE
• Enhance reports with user-defined formats, titles, footnotes and SAS System reporting
• Generate reports using ODS statements
• Control which observations in a SAS data set are processed and output

CHAPTER 9- CREATING AND ACCUMULATING VARIABLES

• Retain Statement
• Sum Statement
• Length Statement
• Accumulating Totals For A Group Of Data

CHAPTER 10- READING RAW DATA USING FORMATTED INPUT

• Multiple Input Statements
• Column Pointers
• Line Pointers
• Single Trailing And Double Trailing

CHAPTER 11- DATA TRANSFORMATION

• SAS Functions
• Date Functions
• Character Functions
• Numeric Functions

CHAPTER 12- PROCESSING DATA ITERATELY

• Do Loop
• Conditional Iterative Processing
• SAS-Array Process
• Proc Transpose

What is the batch size?

SDLC training providing the limited batch size, so we can provide quality teaching. If you want to get trained individually, we are also providing.

How you people will help for the Job?

SDLC training providing the 100% job assistance and mock interviews.

How you people will help in the projects?

SDLC training is providing the training with live projects and real-time practice.

How you people will provide the doubt clarification?

SDLC training providing the 24/7 interact access with faculties and after course also engagement between the faculties and students.

What are the extra services?

SDLC training providing the back up classes, soft skill training, interview skills workshop and resume preparation assistance.

How you people will help to enhance the students knowledge?

SDLC training providing the topics wise ppts, case studies, assignments and doubt solving.

SAS Interview Questions