This course can help prepare you for the following certification exam(s): SAS Certified Professional: Advanced Programming Using SAS 9.4.

Formats available	Standard Duration
Classroom:	2.0 days
Live Web Classroom:	5 half-day session(s)	System Requirements
e-Learning:	14 hours/180 day license	System Requirements

This course addresses Base SAS software.

• Setting up for this course.
• Overview of SAS Foundation.
• Course logistics.
• Course data files.
• Introducing the Structured Query Language.
• Overview of the SQL procedure.
• Exploring tables.
• Specifying columns.

• Subsetting data.
• Presenting data.
• Summarizing data.
• Creating and managing tables.
• Using DICTIONARY tables.

• Introduction to SQL joins.
• Inner joins.
• Outer joins.
• Complex SQL joins.

• Noncorrelated subqueries.
• Correlated subqueries.
• In-line views.
• Creating views with the SQL procedure.
• Subqueries in the SELECT clause.
• Remerging summary statistics.

• Introduction to set operators.
• The INTERSECT operator.
• The EXCEPT operator.
• The UNION operator.
• The OUTER UNION operator.

• Interfacing PROC SQL with the macro language.
• Creating data-driven macro variables with a query.
• Using macro variables in SQL.

• Overview of SAS/ACCESS technology.
• SQL pass-through facility.
• SAS/ACCESS LIBNAME statement.
• PROC FedSQL.