Introduction to Analytics

Introduction to SAS

Scope Of Data Analytics

Know your SAS (Editor File, Log File, Output Window)

Results and Explorer Window

Exposing SAS Environment

SAS Libraries

Step Boundaries & Run- Group Processing

Reading Data into SAS

INFILE Statements & INFILE Options

INPUT Statement & INPUT Options

Concepts fo DATALINES & CARDS

List Input Style

Column Input Style

Formatted Input Style

Mixed Input Style

Modifiers (Colon Modifier, Ampersand Modifiers & Doubling Trailing)

Reading Data Using # pointers, TURNCOVER, SCANNER)

DML, DSD,FIRSTOBS, OBS

Function Definition & Its Uses

Types of SAS Function

Implementation of Character Function

Implementation of Numeric Function

Implementation of Date Function

Learning SAS System Options

LENGTH

FORMATS, IMFORMATS, LABLES

Titles and Footnotes

Reading SAS Datasets with SET Option

Assignment statements

RENAME

DROP and KEEP

Subsetting observations

IF & ELSE IF Statement

Subsetting IF Statement

IN Operator

WHERE Statement

Useful WHERE Operators

Boolean Logic (AND, OR, and NOT Operators)

Introduction to Do Loops

SUM statement

Iterative DO Loop

DO WHILE , DO UNTIL Statements And BY Clause

Nesting Do Loops

LEAVE & CONTINUE Statements

Arrays

Accumulating Totals

RETAIN & SUM

SUM statemnets

SELECT Statements

Deleting Observations

Numeric to Character conversions

PUT & OUTPUT statement

Proc Print

Proc Contents

Proc Sort

Proc Means

Proc Freq

Proc Report

Proc Tabulate

Proc Printto

Proc Dataset

Proc Compare

Proc Transpose

Proc Format (input, put function, creating permanent formats, informats)

Proc Import

Proc Export

Proc Append

Proc Summary

Syntax

One to One merge

Match Merging

Multiple OBS with the same BY Variable

Merging with identical Variable Names

Merging without a Common Variable

Update statement

ODS/Trace/Select/Exclude

ODS/HTML FILE

ODS/PDF FILE

ODS/RTF FILE

PROC PRINT WITH STYLE OPTION

PROC REPORT WITH STYLE OPTION

PROC TABULATE WITH STYLE OPTION

Proc PLOT

Proc GPLOT

Proc CHART

Proc GCHART

SQL DDL Statements (CREATE,ALTER,DROP)

SQL DML Statements (INSERT,UPDATE,SELECT,DELETE)

SQL Filter Clauses (WHERE, GROUP BY, HAVING, ORDER BY)

SQL Horizontal Joins (INNER, LEFT,RIGHT, FULL, FULL with condition, Cartesian product)

SQL Vertical Joins (UNION,UNION ALL,INTERSECT,EXCEPT)

Proc UNIVARIATE

Proc MEANS

Proc FREQ(Chi-Square)

Proc GLM

Proc RANK

Proc ANOVA

Proc REG

Proc LOGISTIC(logistic Regression)

Proc TTEST(Paired)

Proc CORR (correlation)

How to connect with data server

Libname code

Sql Code