SAS SAS SQL

SAS SQL

Catalog: SAS
Short name: SQL
Course start date: 2024-07-02
Paystack

Description

SAS which stands for Statistical Analysis System is a software developed by the SAS Institute a private company based out of Cary, North Carolina, USA. Its primary objective is to be able to process large chunks of data and analyse it to aid in the process of intelligent decision making. SAS has has been widely accepted in the world and it accounts for almost 70% of the data processing market place. SAS/Graph® Training is an essential course, as it is a prerequisite for many courses in the statistical analysis domain.


Through this training you shall be able to Create SAS data sets and run SAS programs effectively.


SAS SQL Overview

Data Step V/S. Proc Sql Processing

Proc SQL Basics

Performing Advanced Queries using Proc SQL

Combining Tables Horizontally using Proc SQL

Combining Tables Vertically using Proc SQL

Creating and Managing Indexes using Proc SQL

Creating and Managing Views using Proc SQL

Managing Processing using Proc SQL

Course Duration:-3h 03m

Sections

General
0 activities

SAS SQL Overview
How to Data Step Work
During the Execution Phase
Proc SQL Basic
Creating a New Columns
Querying Multiple Tables
Basic Queries Using Proc SQL
How to use to Multiple Tables
Performing Advance Queries Using PROC SQL
Sub Query
Sub Setting Rows by Using Calculated Values
Types of Sub Queries
Using Comparisons with Sub Queries
Demo Session
Sub Setting Groups Using Having Clause
Correlated Queries
Understanding Joins
Using Inner Joins
Using a Left Outer Join
Generating Cartesian
Course Certificate

Secure Video
20
Certificate
1
Cost: 5000

Tag

Course Duration:-3h 03m