SAS SAS PROC SQL

SAS PROC SQL

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

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.Through this training you shall learn SAS Proc SQL programming step by step with practical examples and projects.

The training will include the following;


Basic Building Blocks

More Building Blocks

Joins

Subqueries

Set Operators

Global Statements, Options, and Session Management

Using the Macro Facility with PROC SQL

Table Maintenance and Alternate Strategies

Views

PROC SQL as a Report Generator

Mixed Solutions

Performance Tuning

Course Duration:-14h 14m

Sections

General
0 activities

Introduction to Comprehensive PROC SQL - SAS Training
Select Statement
Select Statement Continues
Proc SQL Basic
SQL Operator
SQL Syntax
SQL Group By Statement
Count, Miss and Monotonic Function
Coalesce Function and Sounder Function
Ranuni and Max Function
Ranuni and Max Function Continue
Proc SQL Group By and Order by Statement
Examples of Order by Clause
Examples of Proc SQL Clauses
PROC SQL-Data Set
PROC SQL-Data Set Continues
Selective Statement and Storing Result
Creating New Columns and Aggregation
Constitutionality and Filtering
Example of Filtering
Reordering Row and Elimination of Duplicates
Statistics Based on Original
Source with Inline Views
Ambiguity in Column References
Non Repeating Keys
Repeating Keys
Joins and Mergers
Sub Queries
Sub Queries Continues
Contrasts Between Joins
Interleaving with Outer Joins
Intersect Set Operator
Expect All Set Operator
Global Statements
Generating Proc SQL Code
Populating with Macro Variables
Marco Variables Using SQL Examples
Marco Variables Using SQL Examples Continues
Sql Selection and Maxmin Function
Table Maintenance
Distinguishing Persistent From Replacement
Create Table for Data Maintenance
Modify and Update Data Maintenance Table
Metadata Maintenance
Metadata Data Sets Library
Alter Tables in Metadata Maintenance
Creating Numeric Data
Creating Aliases
Logical Operator
Aligning Characters
Extracting Information from String
Data with Count Function
Non Consecutive Values
PROC SQL-Dictionary
PROC SQL-Report Generator
PROC SQL-Report Generator Continues
Defining Views
Changing Table Via View
Managing Library References
Formatting Output in Proc SQL
Formatting Output Using Scalar Expression
Sub Setting Group with Having Clause
Coding Logic in Proc SQL
Coding Logic in Proc SQL Continues
More on Coding Logic in Proc SQL
Coding Proc SQL
Creating Multiple Macro Variable
Identifying Duplicate Row from Coding
Creating Populating Data in SQL
Create Table Using Like Caluse
Adding Data Using Select Query
Check Constraint in Proc SQL
Establishing Primary and Foreign Keys
Modifying Updating Tables
Creating Simple and Composite Index
Coding Complex Queries
Equi Joins and Reflexive Joins Queries
Performance Computations in Joins
Joins in Proc SQL
Joins in Proc SQL Continues
Complex Queries in Proc SQL
Comparing Complex Queries in Proc SQL
Complex View in Proc SQL
Complex View in Proc SQL Continues
Trouble Shooting and Debugging Techniques
Using INOBS and Loops Option in Trouble Shooting
Prompt and Reset Statement in Trouble Shooting
Tuning Codes in PROC SQL
Tuning Codes in PROC SQL Continues
Subqueries in PROC SQL
More on Subqueries in PROC SQL
Matrix Solution in PROC SQL
Course Certificate
Secure Video
92
Certificate
1
Cost: 5000
Enroll Me

Tag

Course Duration:-14h 14m