SAS Training

SAS Training Overview

The Best SAS Online Training

SAS stands for Statistical Analysis System and this hi tech program training is divided into four major parts and these four are The Data Step, Procedure Step, A meta programming language, a Macro language, and an Output Delivery System. SAS program is quite renowned now around the world and management professional often opt for the course for their professional skill upgradation. KBS Training Institute offers industry compatible online and regular classroom coaching for SAS training. While students may join in regular classroom coaching, professional already working mostly opt for SAS Online Training courses as this course can be attained from home and at flexi timing. KBS training Institute maintains their coaching team with best ERP professional and the institute offers excellent placement assistance.

SAS Training Course Content

SAS Training Course Content

The SAS language

• SAS datasets
• The two parts of a SAS program
• Choosing a mode for submitting SAS programs
• Windows and commands in the SAS windowing environment
• Submitting a program in the SAS windowing environment
• Reading the SAS log
• Viewing your results in the output window
• Creating HTML Output
• SAS datasets with SAS explorer
• Using SAS system Options
• Creation of Independent and Dependent libraries

Getting your data into SAS

• Methods for getting your data into SAS
• Reading files with the Import wizard
• Reading raw data separated by spaces
• Reading raw data arranged in columns
• Selected formats
• Reading Messy raw data
• Reading delimited files with the data step
• Reading delimited files with the Import procedure
• Reading PC files with the Import procedure
• Using permanent SAS datasets with Libname statements

Exporting your data

• Methods for exporting your data
• Writing files using wizard
• Writing delimited and HTML files using ODS
• Writing PC files with the export procedure

Modifying and combining SAS Datasets

• Modifying a Dataset using the SET Statement
• Interleaving datasets using the SET Statement
• Combining Datasets using a One-to-one match merge
• Combining Datasets using a One-to-many match merge
• Updating a master dataset with transactions dataset
• Using SAS dataset Options
• Tracking and selecting Observations with the IN-Option
• Making several observations from one using the output statement changing observations to variables using proc transpose
• Reading messy raw data
• Converting character data type into numeric data type and vice-versa

Working with your data

• Creating and redefining variable
• Using SAS functions
• Using IF-THEN statements
• Grouping observations with IF-THEN/ELSE Statements
• Sub setting your data
• Working with SAS dates
• Selected Date Informats, Functions and Formats
• Using the RETAIN and Sum statements
• Simplifying programs with Arrays
• Using of Put Statements
• Differences between the Put statement and the Put function
• Using of Label Statement
• Using of Length Statement
• Using of Location
• Using of Files statement
• Using of Put Functions
• Using of Where statement
• Using of By statement
• Concept of Formats/Informats
• Creating of User defined Formats and Informats
• Sum statement
• Using of OBS and FIRSTOBS
• Using of Modify statement
• Using of pointers
• File system in SAS
• Execution process of a data step

Enhancing your output with ODS

• Concepts of the Output Delivery system
• Tracing and Selecting procedure Output
• Creating SAS datasets from procedure Output
• Using ODS statements to create HTML output
• Using ODS statements to create PDF output
• Using ODS statements to create RTF output
• Using ODS statements to create PS output
• Using of ODS trace on and trace off statements
• Using of ODS select statement

Automatic Variables

• Using of Automatic Variables
• Using of _N_
• Using of _Null_
• Using of _Error_

Procedures in Base SAS

• Proc Contents
• Proc Append
• Proc Options
• Proc Import
• Proc Export
• Proc Compare
• Proc Datasets
• Proc Transpose
• Proc Format
• Proc Copy
• Proc Sort
• Using of Nodupkeys and noduprec in proc sort

Reporting procedures

• Proc Report
• Proc Tabulate
• Proc Forms
• Proc Chart
• Proc Gchart
• Proc Plot

SAS Macros

• Definition of Macro
• Calling of Macro Variables
• Using of Macro Program
• Adding parameters to Macros
• Examples on Macros
• Macro Functions

SAS SQL

• Introduction to SAS/SQL
• Proc SQL
• Proc SQL Statement
• Concepts of DDL Commands
• Concepts of DML Commands
• Concepts of DQL/DRL Commands
• Concept of Validate Statement
• Describe statement
• Coalesce function
• Upper function
• Order by & group by clauses

JOINS

• Reflexive jobs
• Inner Joins
• Outer Joins
• Normal Joins
• Natural Joins
• Cross Join
• Union Joins

OPERATORS

• Union all
• Intersect
• Except

SAS ACCESS & SAS CONNECT

• Introduction to SAS Access & SAS Connect
• Interface to the RDBMS
• Interface to the PC files

SAS / Warehouse Administrator

• Introduction to Database Management System
• Introduction to ETL
• Related Topic on ETL

SAS / STAT

• Introduction to SAS / Statistics
• Proc Univariate
• Proc Means
• Proc Summary
• Proc Rank
• Proc Freq
• Proc Corr
• Proc Reg
• Proc Anova
• Proc GLM

DEBUGGING YOUR SAS PROGRAMS

• Proc Print Writing SAS programs that work
• Proc Contents Writing SAS programs that don’t work
• Proc Append Searching for missing semicolon
• Proc Compare Lost card
• Proc Options Invalid Data
• Proc Datasets Numeric Values have been converted
• Proc Format to Character and vice-versa