This course is designed to introduce to advanced techniques of SAS programming using Structured Query Language (SQL). This course will help you to prepare for advanced SAS certification exams (SQL part).SQL stands for Structured Query Language. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.SQL is one of the many languages built into the SAS System. Using PROC SQL, the SAS communicates with powerful data manipulation and query tool. Topics covered will include selecting, subsetting, sorting and grouping data--all without use of DATA step code or any procedures other than PROC SQL. THE STRUCTURE OF A SQL QUERY SQL is a language build on a very small number of keywords:SELECT: columns (variables) that you want
FROM: tables (datasets) that you want
ON: join conditions that must be met
WHERE: row (observation) conditions that must be met
GROUP BY: summarize by these columns
HAVING: summary conditions that must be met
ORDER BY: sort by these columnsFor the vast majority of queries that you run, the seven keywords listed above are all you’ll need to know. There are also a few functions and operators specific to SQL that can be used in conjunction with the keywords above. SELECT is a statement and is required for a query. All the other keywords are clauses of the SELECT statement. The FROM clause is the only one that is required. The clauses are always ordered as in the list above and each clause can appear, at most, once in a query. The nice thing about SQL is that, because there are so few keywords to learn, you can cover a great deal in a short duration. So, let’s get on with the learning!
Facilities
Location
Start date
Online
Start date
Different dates availableEnrolment now open
About this course
PROC SQL Syntax
SELECT statement and Columns
Where CLAUSE
CASE Logic
Summary Functions
Inner Join
Joining Three Tables
Left/Right Join
Full Join (using coalesce function)
Creating A Table
Altering Columns
Inserting Rows with a Query
Comparing Tables
Finding Duplicate Records
Customize The Way You Sort
Questions & Answers
Add your question
Our advisors and other users will be able to reply to you
We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.
Thank you!
We are reviewing your question. We will publish it shortly.
Or do you prefer the center to contact you?
Reviews
Have you taken this course? Share your opinion
This centre's achievements
2021
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 4 years
Subjects
Programming
Logic
Syntax
SQL
Course programme
Introduction
3 lectures08:47Course CurriculumWhat is SQL and How it comes into the picture of SAS?Meet the Instructor
Introduction
3 lectures08:47Course CurriculumWhat is SQL and How it comes into the picture of SAS?Meet the InstructorCourse CurriculumCourse CurriculumCourse CurriculumCourse CurriculumWhat is SQL and How it comes into the picture of SAS?What is SQL and How it comes into the picture of SAS?What is SQL and How it comes into the picture of SAS?What is SQL and How it comes into the picture of SAS?Meet the InstructorMeet the InstructorMeet the InstructorMeet the Instructor
Basic Knowledge of SQL
6 lectures33:28SQL SyntaxSELECT statement and Columns (Variables,Calculated Value,Formatted Value)CASE LogicSummary FunctionsA Small Assignment [Problem Statement Discussion]Assignment Solution
Basic Knowledge of SQL
6 lectures33:28SQL SyntaxSELECT statement and Columns (Variables,Calculated Value,Formatted Value)CASE LogicSummary FunctionsA Small Assignment [Problem Statement Discussion]Assignment SolutionSQL SyntaxSQL SyntaxSQL SyntaxSQL SyntaxSELECT statement and Columns (Variables,Calculated Value,Formatted Value)SELECT statement and Columns (Variables,Calculated Value,Formatted Value)SELECT statement and Columns (Variables,Calculated Value,Formatted Value)SELECT statement and Columns (Variables,Calculated Value,Formatted Value)CASE LogicCASE LogicCASE LogicCASE LogicSummary FunctionsSummary FunctionsSummary FunctionsSummary FunctionsA Small Assignment [Problem Statement Discussion]A Small Assignment [Problem Statement Discussion]A Small Assignment [Problem Statement Discussion]A Small Assignment [Problem Statement Discussion]Assignment SolutionAssignment SolutionAssignment SolutionAssignment Solution
Joining
6 lectures26:13Inner JoinJoining Three TablesLeft/Right JoinFull Join (using coalesce function)A Small Assignment on Joining [Problem Statement Discussion]Assignment Solution on Joining
Joining
6 lectures26:13Inner JoinJoining Three TablesLeft/Right JoinFull Join (using coalesce function)A Small Assignment on Joining [Problem Statement Discussion]Assignment Solution on JoiningInner JoinInner JoinInner JoinInner JoinJoining Three TablesJoining Three TablesJoining Three TablesJoining Three TablesLeft/Right JoinLeft/Right JoinLeft/Right JoinLeft/Right JoinFull Join (using coalesce function)Full Join (using coalesce function)Full Join (using coalesce function)Full Join (using coalesce function)A Small Assignment on Joining [Problem Statement Discussion]A Small Assignment on Joining [Problem Statement Discussion]A Small Assignment on Joining [Problem Statement Discussion]A Small Assignment on Joining [Problem Statement Discussion]Assignment Solution on JoiningAssignment Solution on JoiningAssignment Solution on JoiningAssignment Solution on Joining
Working with Tables
5 lectures23:43Creating A TableAltering Columns (add, modify, delete + adding values to column)Inserting Rows with a Query and SET statement + Deleting RowsA Small Assignment on Tables [Problem Statement Discussion]Assignment Solution on tables
Working with Tables
5 lectures23:43Creating A TableAltering Columns (add, modify, delete + adding values to column)Inserting Rows with a Query and SET statement + Deleting RowsA Small Assignment on Tables [Problem Statement Discussion]Assignment Solution on tablesCreating A TableCreating A TableCreating A TableCreating A TableAltering Columns (add, modify, delete + adding values to column)Altering Columns (add, modify, delete + adding values to column)Altering Columns (add, modify, delete + adding values to column)Altering Columns (add, modify, delete + adding values to column)Inserting Rows with a Query and SET statement + Deleting RowsInserting Rows with a Query and SET statement + Deleting RowsInserting Rows with a Query and SET statement + Deleting RowsInserting Rows with a Query and SET statement + Deleting RowsA Small Assignment on Tables [Problem Statement Discussion]A Small Assignment on Tables [Problem Statement Discussion]A Small Assignment on Tables [Problem Statement Discussion]A Small Assignment on Tables [Problem Statement Discussion]Assignment Solution on tablesAssignment Solution on tablesAssignment Solution on tablesAssignment Solution on tables
Practical Application Of SQL in SAS
7 lectures23:42Comparing TablesFinding Duplicate RecordsAssignment Only Displaying Unique records/rows[Problem Statement ]Assignment Only Displaying Unique records/rows[Solution ]Customize The Way You SortShort Assignment [Problem]Short Assignment [Solution]
Practical Application Of SQL in SAS