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
Scroll to Top