SAS Certified SAS Base Programmer

Certified SAS Base Programmer

Catalog: SAS
Short name: Certified SAS Base Programmer
Course start date: 2024-07-02
Paystack
Enroll Me

Description

This is a comprehensive course on SAS Base Programming which has over 21 hours of lecture divided into two major sections consisting of 115 sub modules. The course has been divided into the following Sections and sub topics.


Section 1: Business Analytic Using SAS

In this  section you will be given an introduction to the SAS Program and learn about SAS Dataset and SAS Formats. How to read Excel Worksheets and what are the Raw Data File Standards and Non Standards will be elaborated. Here you will also get to know about Length Statement and Compilation Execution and various types of Data Errors. You will learn various ways of Validation of Data sets and also learn about various types of Statements like Assignment Statement, If Then Statement and Diff Where and If Statement. You will learn how to work with databases with help of Keep Drop, Append, Concatenate and Merge Data Bases. You will learn how to generate Global Statements and give Title n Foot Note. You will also be given an over view of various SAS functions and various types of Arrays like Array DoLoop and Array Temp. You will be also trained on how to generate SAS Statements.


Section 2: SAS – Advanced SAS For Business Analytics

Here you will get an introduction to Advanced SAS and learn about Macro and how to develop Macros Applications. You will also learn about various Macrovariables and how to define and call Macro. In this chapter you will also be given a overview of Positional Parameters. You will learn how to create and update variables. You will also get trained on working with SQL inside SAS. You will also be given an overview of the NOEXEC along with practical examples. In this chapter you will also learn about various types of functions like Average Function, Minimum Function, Count Function and Executing Count Function. You will also get detailed insight on Clauses like Group by Clause, Executing Group by and Having Clause, Executing Order By Clause. What is SubQuery and how to Execute SubQuery will be demonstrated. You will also get detailed overview of SQL Joins and how to Create a Table in SQL and work with the SQL View. You will learn how to Insert Data into Table and also learn various Techniques for Programming Efficiency.

Course Duration:-12h 48m

Sections

General
0 activities

SAS Introduction
Introduction to SAS Program
Read SAS Dataset
Practice Read Dataset
Practical Example on Read Dataset
Introduction to SAS Dataset
SAS Dataset Practical Example
SAS Dataset Practical Program
DateValue
SAS Formats Part 1
SAS Formats Part 2
Reading Excel Worksheets
Reading Excel Worksheet Example
Date Format Example
Raw Data File Standard Part 1
Raw Data File Standard Part 2
Raw Data File Standard Example
Raw Data File Non Standard
Raw Data File Non Standard Example
Length Statement
Compilation Execution
Heading
Dataerrors
Data Errorsz Example
Validate Data Procfreq
Validate Data Procpront
Validate Data Peocmeans
Dat Constant
Assignment Statement
If Then Statement
If Then Do End Statement
Diff Where and If Statement
Keep Drop
Keep Drop Example
Append
Append Examples part 1
Append Examples part 2
Concatenate
Merge
Merge One to One
Merge One to Many
Merge Non Match
Global Statements
Global Statements Examples Part 1
Global Statements Examples Part 2
Title n Foot Note
Title n Foot Note Example
By Statement
Multiple Where Stament
ODS
ODS Example
Sas Date Function
Sas Date Function Example
Sas Functions Part 1
Sas Functions Part 2
Sas Functions
Sas Functions Example Part 1
Sas Functions Example Part 2
Multiple SAS Datasets Part 1
Multiple SAS Datasets Part 2
Multiple SAS DatasetsExample
Select Group
Select Group Example
Do Loop Part 1
Do Loop Part 2
Do Loop Example
Array Part 1
Array Part 2
Array DoLoop
ArrayTemp
Array Example
Sas Statement Part 1
Sas Statement Part 2
Introduction To Advanced Sas
Why Macro
Developing Macro Applications
Token
Macrovariables
Macrovariables Examples
Macrovariables Demo
Defining And Calling Macro
Demo
Macro - Putting Code
Macro Programming
Example For Macro Programming
Positional Parameters
Positional Parameters Example
Where Are Macro Variables Stored
Creating & Updating Variables
Sas With Sql
Understanding Sql Procedure
How To Use Sql In Sas
Noexec Keyword
Practical Examples- Noexec
Average Function
Minimum Function
Count Function
Executing Count Function
Group By Clause
Executing Group By And Having Clause
Order By Clause
Executing Order By Clause
Subquery
Executing Subquery
What Are Sql Joins
Syntax For The Outer Join
Practical Example For Joins
Creating A Table In Sql
Understanding Sql View
Inserting Data Into Table
Techniques For Programming Efficiency
Practical Example For Creating Table
Practical Example For Inserting Data Into Table
Practical Example For Deleting Record From Table
Practical Example For View
Course Certificate
Secure Video
115
Certificate
1
Cost: 5000
Enroll Me

Tag

Course Duration:-12h 48m