SQL for the SAS Programmer/Analyst

SAS for SQL is a Most Demanding Topic Now a Days.

In this course you will learn:

What is SQL and How it comes into the picture of SAS?

Installation

SQL Syntax

SELECT statement and Columns, Where Clause

CASE Logic

Summary Functions

ASSIGNMENT PROBLEMS

Assignment Solution Quiz [3-5 Questions]

Inner Join

Joining Three Tables

Left/Right Join

Full Join (using coalesce function)

A Small Assignment on Joining [Problem Statement Discussion]

Assignment Solution

Creating A Table

Inserting Rows with a Query and SET statement + Deleting Rows

Altering Columns (add, modify, delete + adding values to column)

A Small Assignment on Tables [Problem Statement Discussion]

Assignment Solution Quiz [3-5 Questions]

Comparing Tables

Finding Duplicate Records

Assignment Only Displaying Unique records/rows[Problem Statement ]

Assignment Only Displaying Unique records/rows[Solution ]

Customize The Way You Sort

Short Assignment [Problem]

Short Assignment [Solution]Quiz [3-5 Questions]