Study Learn Grow
SQL for Advanced SAS Programming : Learn Hand-On

SQL for Advanced SAS Programming : Learn Hand-On

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).

Overview

Description
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 columns
For 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!

Basic knowledge
No such knowledge of programming is required

Course Information

No such knowledge of programming is required

What will you learn
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

Anyone interested in learning SQL in SAS
Anyone who wants to explore their career in SAS

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs