Weekendr: Data Science | Data & Business Analytics | Placement Prep

About

SAS Certificate Training - Weekendr Bootcamps

Prerequisites

Basic Knowledge of Statistics will be helpful

Faculty Profile

Experience in Business Analysis, Creating Excel Dashboard, Business & Financial Modeling, and Data Modeling Quantitative Analysis of Companies – Relative valuation, Profitability analysis, Cash flow analysis and price analysis Experience in VBA Macro & Capital IQ, SAS, Business Objects XI

Curriculum

Introduction to SAS

Introduction
What is SAS ? Need for SAS ? Who uses SAS ?
Overview of Base SAS Software
Data Management Facility, Structure of SAS Dataset
SAS Program, Programming Language, Elements of the SAS Language
Rules for SAS Staements, SAS Names, Variable names, Types of SAS Variables
Data Analysis and reporting utilities, Traditional Output
Ways to run SAS Programs, SAS Windowing Environment
Non Interactive Mpde, Batch Mode, Interactive Line Mode
Running programs in SAS Windowing Environment

How SAS Works

Writing your first SAS Program
A Simple Program To Read Raw Data And Produce A Report
Enhancing The Program
More On Comment Statements, Internal Processing In SAS
How SAS Works - The Compilation Phase, The Execution Phase
Processing A Data Step: A Walkthrough
Creating The Input Buffer And The Program Data Vector
SAS Libraries, Work Library

Reading Raw Data Into SAS

What Is Raw Data, Definitions, Data Values, Numeric Value, Character Value
Standard Data, Nonstandard Data, Numeric Data, Character Data
Choosing An Input Style, List Input, Modified List Input, Column Input, Formatted Input, Named Input, Instream Data
Creating Multiple Records From Single Input Row
Reading Data From External Files
Reading Blank Separated Values (list Or Free Form Data):
Reading Raw Data Separated By Commas (.csv Files):, Reading In Raw Data Separated By Tabs (.txt Files):
Using Informats With List Input, Supplying An Informat Statement With List Input
Using List Input With Embedded Delimiters
Reading Raw Data That Are Aligned In Columns: Method 1: Column Input, Method 2: Formatted Input
Using More Than One Input Statement: The Single Trailing @
Reading Column Data That Is On More Than One Line
Mixed-style Input: Infile Options For Special Situations, Missover, Truncover, Pad
Using Lrecl To Read Very Long Lines Of Raw Data
Checking Your Data After It Has Been Read Into SAS

Reading Data From A Dataset

Introduction, Set Statement Overview
Automatic Variables In SAS, Interleave Multiple SAS Data Sets, Combine Multiple SAS Data Sets
Creating & Modifying Variable, Creating Multiple Datasets In A Single Data-step
Subsetting Observations, Conditional SAS Statements
Logical And Special Operators, The SAS Supervisor And The Set Statement
Efficiency And The Set Statement, Know Your Data
Set Statement Data Set Options, Drop And Keep Options, Rename Option
Firstobs And Obs Options, Where Option -, Other Set Statement Options, Nobs Option, Point Option
Do Loops And The Set Statement
Introduction To Retain Statement, Carry Over Values From One Observation To Another, Compare Values Across Observations
Assign Initial Values, Determining Column Order In Output Dataset, SAS System Options
Input SAS Data Set For Example
Selecting Observations For A New SAS Data Set
Deleting Observations Based On A Condition, Accepting Observations Based On A Condition
Comparing The Delete And Subsetting If Statements, Methods Of Creating New Data Sets With A Subset
Subsetting Records From An External File With A Subsetting If Statement
Subsetting Observations In A Data Step With A Where Statement, Subsetting Observations In A Proc Step With A Where Statement
Subsetting Observations In Proc Sql, Difference Between If And Where

SAS Informats And Formats

Overview, Using SAS Informats
Input Statement, Input Function, Inputn And Inputc Functions
Attrib And Informat Statements
Using SAS Formats, Format Statement In Procedures, Put Statement, Put Function, Additional Comments

SAS Functions

Categories Of Functions
SAS Character Functions -Functions That Change The Case Of Characters - Upcase, Lowcase, Propcase
Functions - Miscellaneous String Functions, SAS Date And Time Functions
Introduction - What Is A SAS Date And Time Literal?, Date And Time Functions, Functions To Get Quarter ,year Or Day Of The Date, Functions That Work With Intervals
Using Formats For Date And Time, System Options Fordate And Time

An Introduction To Arrays And Array Processing

Why Do We Need Arrays?, Basic Array Concepts
Array Statement, Array References, Variable Name Array Reference
One Dimension Arrays, By - Group Processing, Definitions For By-group Processing, By-group Processing, By Value, By Group
First.variable And Last.variable - Modifying SAS Data Sets: Examples., Invoking By-group Processing
Preprocessing Input Data For By-group Processing, Sorting Observations For By-group Processing, Indexing For By-group Processing
How The Data Step Identifies By Groups, Processing Observations In A By Group, How SAS Determines First.variable And Last.variable
Processing By-groups In The Data Step, Overview, Processing By-groups Conditionally, Data Not In Alphabetic Or Numeric Order, Data Grouped By Formatted Values

Overview Of Methods For Combining SAS Data Sets

Definitions, Concatenating, Interleaving, One-to- One Reading Or One-to-one Merging, Match-merging
Updating, Modifying, Definitions For Reading, Combining, And Modifying SAS Data Sets
Reading A SAS Data Set, Combining SAS Data Sets, Modifying SAS Data Sets
Overview Of Tools, Reading SAS Data Sets, Reading A Single SAS Data Set, Reading From Multiple SAS Data Sets
Combining SAS Data Sets: Basic Concepts, One-to-one, One-to-many And Many-to-one, Many-to-many
Access Methods: Sequential Versus Direct, Sequential Access, Direct Access, One-to-one Reading, Data Step Processing During A One-to-one Reading
One-to-one Merging, Match-merging
Updating With The Update And The Modify Statements : Definitions, Syntax Of The Update Statement, Syntax Of The Modify Statement -
Updating With Nonmatched Observations, Missing Values, And New Variables - Using An Index With The Modify Statement

SAS Procedures

Introduction, The Proc Statement, Title And Footnote Statements, By Statement, Label Statement, Format Statement, Run Or Quit Statement
Description Of Data Used In Reports, SAS Reporting Procedures, Using Proc Print, Using Proc Sql, Proc Report, Procs That Summarize
Using Proc Chart, Using Proc Freq, Using Proc Means, Using Proc Univariate
Introduction To Proc Tabulate, Proc Sort, Proc Format, Proc Contents, Other Important Procs, Proc Transpose, Definitions, Proc Append
How To Import An Excel File Into SAS

Enhancing Your Output With Ods

Concepts Of The Output Delivery System
Tracing And Selecting Procedure Output
Creating SAS Data Sets From Procedure Output
Using Ods Statements To Create Html Output

Writing Flexible Code With The SAS Macro Facility

Macro Concepts, Substituting Text With Macro Variables, Creating Modular Code With Macros
Adding Parameters To Macros
Writing Macros With Conditional Logic
Writing Data-driven Programs With Call Symput, Debugging Macro Errors

Exporting Your Data

Methods For Exporting Your Data
Writing Raw Data Files With The Data Step

Proc Graph

One Dimensional Graphical Presentation Of Data With Proc Gchart
Two Dimensional Graphical Presentation Of Data With Proc Gplot

SAS

SAS