SAS SQL for the SAS Programmer/Analyst

SAS SQL. SQL for SAS. If you have knowledge of SAS data step programming, learn Proc SQL now!

Created by: Ermin Dedic
All Things Data.

What Will I Learn?

• Apply SQL syntax (like SELECT, WHERE, HAVING, GROUP BY, ORDER BY)
• Join tables (Inner join, left/right join, joining three tables, and full join)
• Managing tables (from how to create one, to how to alter columns, add rows)
• How to apply SQL to compare tables, find duplicate records, create conditions + more

Requirements

• Internet connection
• A good knowledge of SAS data step

Target audience

• Students who have a base knowledge of SAS programming using the data step
• Students who are interested in developing their SQL skills