Ultramax Infonet Education

Call Us

+91-9284425283 / +917498212715

Mail Us

sales@ultramaxit.com

Admission on going

  • Advance SAS

SAS® Macro Language: Essentials

Lesson 1 Introduction

  • Why SAS Macro?
  • Setting Up for This Course

Lesson 2 The SAS Macro Facility

  • Program Flow and Tokenization
  • Creating and Using Macro Variables

Lesson 3 Storing and Processing Text

  • Macro Functions
  • Working with Special Characters
  • Using SQL to Create Macro Variables
  • Using the DATA Step to Create Macro Variables
  • Lookup Tables and Indirect Referencing

Lesson 4 Working with Macro Programs

  • Defining and Calling a Macro
  • Macro Variable Scope
  • Conditional Processing
  • Iterative Processing

Lesson 5 Advanced Macro Techniques

  • Storing User-Defined Macros for Reuse
  • User-Defined Macro Functions
  • User-Defined Macro Utilities
  • Data-Driven Macro Call

SAS® SQL 1: Essentials

Lesson 1 Essentials

  • Setting Up for the Course
  • What Is SQL?
  • Introduction to the SQL Procedure

Lesson 2 PROC SQL Fundamentals

  • Generating Simple Reports
  • Summarizing and Grouping Data
  • Creating and Managing Tables
  • Using DICTIONARY Tables

Lesson 3 SQL Joins

  • Introduction to SQL Joins
  • Inner Joins
  • Outer Joins
  • Complex Joins

Lesson 4 Subqueries

  • Subquery in WHERE and HAVING Clauses
  • In-Line Views (Query in the FROM Clause)
  • Subquery in the SELECT Clause

Lesson 5 Set Operators

  • Introduction to Set Operators
  • INTERSECT, EXCEPT, and
  • UNION
    OUTER UNION

Lesson 6 Using and Creating Macro Variables in SQL

  • Creating User-Defined Macro Variables
  • Creating Data-Driven Macro Variables with PROC SQ

Lesson 7 Accessing DBMS Data with SAS/ACCESS®

  • Overview of SAS/ACCESS Technology
  • SQL Pass-Through Facility
  • SAS/ACCESS LIBNAME Statement
  • FEDSQL Procedure

Don't Miss Out on Our Business Resources
Feel Free to contact us for Demo
Feel Free to contact us for Demo
Scroll to Top