Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

SAS SQL - Essentials

( Duration: 2 Days )

The SAS SQL - Essentials training course teaches to process SAS data using Structured Query Language (SQL).

By attending SAS SQL - Essentials workshop, delegates will learn to:

  • Query and subset data
  • Summarize and present data
  • Combine tables, including complex joins and merges
  • Create and modify table views and indexes
  • Replace multiple DATA and PROC steps with one SQL query

Knowledge of:

  • Submitting SAS programs on the operating system
  • Create and access SAS data sets
  • Use arithmetic, comparison, and logical operators
  • Invoke SAS procedures

  • This SAS SQL - Essentials class is intended for SAS programmers and business analysts

COURSE AGENDA

1

Essentials

  • Overview of SAS Foundation
  • Introducing the Structured Query Language
  • Overview of the SQL procedure
  • Exploring tables
  • Specifying columns
2

PROC SQL Fundamentals

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

SQL Joins

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

Subqueries

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

Set Operators

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

Using and Creating Macro Variables in SQL

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

Accessing DBMS Data with SAS/ACCESS

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X