SAS

Course Overview:

This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses. You will know how to use SAS Studio to write and submit SAS programs that access SAS, Microsoft Excel, and text data. You will know how to explore and validate data, prepare data by subsetting rows and computing new columns, analyze and report on data, export data and results to other formats, use SQL in SAS to query and join tables.

Course Content:

Introduction

♦ What is SAS

♦ Why Choose SAS

♦ Installation

First Steps

♦ Introduction To SAS System & Architecture

♦ History And Various Modules

♦ Features

Operators, Functions, Datasets

♦ Variables & SAS Syntax Rules

♦ Creating & Redefining Variables

♦ SAS Data Sets

♦ Data Set Options

♦ Operators

♦ Reading Raw Data

♦ Working With External Files & Options

♦ Multiple Observations

♦ Input Styles

♦ Modifying And Combining Data Sets

♦ Updating Master Data Set

♦ SAS Functions

Statements & Loops

♦ Infile Statement With Options

♦ Select Statement

♦ Leave and Continue Statements

♦ Where Statement

♦ If – Then Else Statement

♦ Goto, Stop And Error Statements

♦ Output Statement, Put Statement

♦ Do Loops

♦ Display Manager Commands

Arrays & Methods

♦ An Introduction To Arrays And Array Processing

♦ Overview Of Methods For Combining Sas Data Sets

BASE SAS PROCEDURES

Tabulating and Summarizing Data

♦ Proc Freq

♦ Proc Means

♦ Proc Univariate

Graphing Data

♦ Proc Chart

♦ PROC TIMEPLOT

Graphing Using SAS/Graph

♦ PROC GCHART

Relationships between Two Quantitative Variables

♦ Proc Plot

♦ PROC GPLOT

♦ PROC CORR

♦ PROC REG

Variable and a Quantitative Variable

♦ PROC TABULATE

Producing Data

♦ Proc Plan

Control Charts

♦ PROC SHEWHART

Others

♦ Proc sort

♦ Proc Print

♦ Proc Copy

♦ Proc Summary

♦ Proc Append

♦ Proc Datasets

♦ Proc Contents

♦ Proc Delete

♦ Proc Format

♦ Proc Import

♦ Proc Export

Advanced SAS

SAS/SQL

♦ Introduction To SAS/ SQL

♦ Features

♦ Uses

♦ Terminology

♦ Data Types, Key Words, & Operators

♦ Functions, Predicates

♦ Formatting Output

♦ Group By Clause

♦ Order By Clause

♦ Having Clause

♦ Case Expression And Conditional Logic.

♦ Creating ,Populating & Deleting Tables

♦ Alter Table Statement

♦ Changing Column’s Length

♦ Joins

♦ Constraints

♦ Renaming A Table & Columns

♦ Views

SAS/MACROS

♦ Macro Concepts

♦ Macros And Macro Variables

♦ Creating Macro Variables

♦ Using Macro Variables

♦ Creating Modular Code With Macros

♦ Invoking A Macro

♦ Adding Parameters To Macros

♦ Macros With Conditional Logic

♦ Using Various Procedures In Macros

♦ Automatic Variables

♦ Macro Functions

♦ Including External Macros

SAS/ODS

♦ Creating RTF File

♦ Creating Html File

♦ Creating Pdf File

SAS/GRAPH

♦ Chart Procedure

♦ Vertical, Horizontal, Pie

♦ Group, Subgroups

♦ Plot Procedure

♦ Multiple Plots & Overlay

♦ Symbol Statement

♦ Title And Footnote Statements

SAS/REPORTS

♦ Frequency Report

♦ One-Way Frequency Report

♦ Cross Tabular Frequency Report

♦ Summary Statistics

♦ Creating A List Report

♦ Define Statement

♦ Order Usage and Group

♦ Printing Grand Totals

♦ Rbreak Statement

♦ Tabulate Procedure

♦ One-Dimensional Tables

♦ Two-Dimensional Tables

♦ Obtaining A Total

♦ Analysis Variables with options

♦ Summary Statistics

SAS/STAT

♦ Proc Univariate

♦ Proc Corr

♦ Proc Reg

♦ Proc Anova

We can assure a 100% job guarantee and Placement. Contact us for Free - Demo.