Loader
whatsapp

TRAINING

Enroll Now sas-advance-training.

Online TrainingOnline Training

Corporate TrainingCorporate Training

Course On DemandClassroom

SAS COURSE CURRICULUM

SAS COURSE OVERVIEW

The SAS Training Course is designed to provide concept and skills of SAS Programming language, tools and several leading statistical techniques to become a successful Analytics professional. These techniques can be enforced to carry out advanced SAS programming. The course is fed with series of interactive exercises, which makes the learning more effective. 

COURSE OBJECTIVE

The Course goes with the aim to understand key concepts about

  • To understanding working with SAS programming upon Windows platform
  • To get basic knowledge about SAS programming
  • Learning to create SAS data sets
  • To master in Data step processing
  • To excel in managing data
  • Integrate various modules by combining SAS data sets
  • Writing the data on external files and also to learn Generating reports
  • To develop basic skills in debugging
  • To improve problem solving skills

WHO SHOULD TAKE THIS COURSE

Anyone who wants to learn programming with SAS can start right away! The course is exclusively designed for students and professionals aspiring to make a career in Data Analytics with SAS. 

  • Analytics professionals who want to work with SAS.
  • IT professionals looking for a career switch in the fields of analytics
  • Software developers interested in pursuing a career in analytics
  • Graduates looking to build a career in analytics and data science
  • Experienced professionals who would like to harness data science in their fields

Other professionals, from technology field, willing to acquire a solid foundation of this widely-used Analytical language, can also opt for this course.

WHAT ARE THE PREREQUISITES FOR LEARNING SAS

Anybody can learn SAS and get trained. Having a basic knowledge of SQL can help.

Getting started with SAS

Introduction
  • SAS Installation and Access
  • Nuts and bolts of SAS programming steps
  • SAS Input Statement
  • DATA Step Statement
  • Key Data Ware House Concepts
  • Execution of SAS Programs (Compile & Execution)
Overview of SAS Statements
  • SAS Comments
  • SAS Data set definition
  • SAS Data Types
  • Two parts of SAS Program
  • Difference between DATA and PROC Steps
Navigating the SAS windows environment
  • Editor,Log,Output,Explorer,Results windows
  • Submitting a SAS Program
  • Reading SAS log and Output window
  • Referencing files/folders into SAS
  • SAS Libraries (Permanent & Temporary)
  • SAS Data sets with SAS Explorer
  • SAS Products / Modules
  • SAS in different Sectors
  • SAS System Options
  • SAS Global Statements

SAS BASE

DATA ACCESS
  • SAS Programs (Saving,Editing,Opening a stored program)
  • Steps to create a SAS Dataset from raw data
  • Referencing a SAS Library
  • Storage of Dataset (Temporarily & Permanently)
  • Informats & Formats
  • Creating & Applying user defined formats
  • Methods for getting data into SAS
  • Entering Data into a view table
  • Reading internal raw data (List,Column,Formated & Mixed Inputs)
  • Reading external raw data (Infile Statement)
  • Import Wizard method
  • Proc Import
  • Testing your Program
  • Assignment
  • Assignment Solution
  • Key Takeaways
Data Management
  • Reading data from one dataset to another dataset
  • Sub- setting Data
  • Creating and Modifying Variables
  • SAS Datasets Statements
  • SAS Dataset Options
  • Merge Concept
Conditional Statements & Loops
  • If Statement
  • Nested if Statement
  • Do loop
  • Do while & DO Until
  • Arrays
  • Assignment
  • Assignment Solution
  • Key Takeaways
SAS Functions
  • Character Functions
  • Numeric Functions
  • Date Functions
  • Time Functions
  • Changing variable types
Utility SAS Procedures
  • Proc Print
  • Proc Setinit
  • Proc Append
  • Proc Sort
  • Proc Format
  • Proc Compare
  • Proc Transpose
  • Proc Rank
  • Proc Copy
  • Proc Catalog
  • Proc Cport
  • Proc Cimport
  • Proc Datasets
    1. Assignment
    2. Assignment Solution
    3. Key Takeaways
SSAS/STAT for Analysis
  • Proc Freq
  • Proc Transpose
  • Proc Standard
  • Proc Univaraite
  • Proc Means/Summary
  • Proc Corr
  • Proc Reg
SAS ODS Data Presentation
  • ODS Concept
  • SAS output in different panels
  • RTF
  • HTML
  • PDF
  • XML
  • MS-Office
Reporting Procedures
  • Proc Print
  • Proc Tabulate
  • Proc Report
  • Proc Export
  • Custom Reporting
  • Using _null_ special dataset
  • Put and file statements for customization
    1. Assignment
    2. Assignment Solution
    3. Key Takeaways
SAS/Graphs Plot Procedures
  • Proc plot
  • Proc Gplot
  • Proc Chart
  • Proc GChart
  • Proc G3D
  • PROC SGPLOT
  • Proc GBarLine

Advanced SAS

SAS SQL
  • Introduction to SQL
  • SQL Terminology
  • SQL Statements
  • Introduction to SAS SQL (Proc SQL)
  • SQL categories
  • Importance of PROC SQL
  • Creating & Deleting Tables
  • Overview of SELECT Statement
  • ORDER BY Clause
  • GROUP BY
  • WHERE Clause
  • SQL Joins
  • Concept of views
  • Case Operator
    1. Assignment
    2. Assignment Solution
    3. Key Takeaways
SAS MACROS
  • Introduction to Macros
  • Uses of Macros
  • Macro Concepts (Macros Processor , Components)
  • Types of Macros (Automatic & User Defined)
  • Macro Variables (Local & Global)
  • Creating Macro Variables
    1. %Let Statement
    2. %Do Statement
    3. % Local
    4. %Global
    5. %Macro (with or without parameters)
    6. Call Symput in Data Step
  • Macro Parameters (Key word & Positional)
  • Macro Function
  • Macro Conditions (%If, %If % then…)
  • Invoking Macros
  • Debugging Macro Errors (Mprint,Mlogic,Symbolgen)
    1. Assignment
    2. Assignment Solution
    3. Key Takeaways

United Global Soft Key Features

Expert Instructors

Practical Implementation

Real- time Case Studies

Certification Guidance

Resume Preparation

Placement Assistance

Copyright 2018 © www.unitedglobalsoft.com . All right reserved | Sitemap | Privacy Policy | Terms Of Services