SAS Advanced Programmer

SAS Macro Language 1: Essentials

Learn Modern Technology This course is for users who want to learn sophisticated tools to fully explore the potential of SAS using Base SAS Software.
  • Introduction
    • Overview of SAS Foundation
    • Program flow
  • Macro Variables
    • Introduction to macro variables
    • Automatic macro variables
    • Macro variable references
    • User-defined macro variables
    • Delimiting macro variable references
    • Macro functions
  • Macro Definitions
    • Defining and calling a macro
    • Macro parameters
  • DATA Step and SQL Interfaces
    • Creating macro variables in the DATA step
    • Indirect references to macro variables
    • Creating macro variables in SQL
  • Macro Programs
    • Conditional processing
    • Parameter validation
    • Iterative processing
    • Global and local symbol tables
Experienced SAS programmers who have a sound understanding of DATA step processing
  • Participants should have completed the SAS Programming 2: Data Manipulation Techniques course or have equivalent knowledge.
  • Use a DATA step to read from or write to a SAS data set or external file
  • Learn to use the components of the SAS macro facility and how to design, write, and debug macro systems.
  • Perform text substitution in SAS code
  • Automate and customize the production of SAS code
  • Conditionally or iteratively construct SAS code
  • Use macro variables and macro functions.
Delivery Method : Classroom Training / Live Web / Self Learning
Duration : 14 hours
Level : Fundamental
Languages : English

SAS SQL 1: Essentials

Learn Modern Technology This course is for users who want to work extensively with SAS software to bring value to the table.
  • Introduction to SQL
  • Building Basic Queries using SQL procedures
  • Displaying Query Results
  • Using SQL Joins
  • Performing Subqueries
  • Using Operators
  • Creating Tables and Views
  • Advanced PROC SQL Features
Experienced SAS programmers
  • Execute SAS programs on your operating system
  • Create and access SAS data sets
  • Use arithmetic, comparison, and logical operators
  • Use SAS procedures.
Learn how to
  • Query, subset, summarize and present data
  • Create and modify table views and indexes
  • Combine tables, including complex joins and merges
  • Replace multiple DATA and PROC steps with one SQL query.
Delivery Method : Classroom Training / Live Web / Self Learning
Duration : 17.5 hours
Level : Fundamental
Languages : English

SAS Programming 3: Advanced Techniques and Efficiencies

Learn Modern Technology This course is for users who want to learn go deep into the realms of data analysis the most essential part of using digital technology today using Base SAS Software.
  • Introduction
  • How to write Efficient SAS Programs
    • SAS DATA step processing
    • Controlling I/O
    • Reducing the length of numeric variables
    • Compressing SAS data sets
    • Using SAS views
  • Accessing Observations
    • Access methods
    • Accessing observations by number
    • Creating and using an index
  • DATA Step Arrays
    • Introduction to lookup techniques
    • One-dimensional arrays
    • Multidimensional arrays
    • Loading a multidimensional array from a SAS data set
  • DATA Step Hash and Hiter Objects
    • Hash object methods
    • Loading a hash object from a SAS data set
    • DATA step hiter object
  • Combining Data Horizontally
    • DATA step merges and SQL procedure joins
    • Using an index to combine data
    • Combining summary and detail data
    • Combining data conditionally
  • User-Defined Functions and Formats
    • user-defined functions and formats
Experienced SAS programmers
  • This course is not appropriate for beginning SAS software users.
  • Before attending this course, you should have at least nine months of SAS programming experience
  • Should have completed the Data Manipulation Techniques course
Learn how to compare various SAS programming techniques that enable you to
  • Benchmark computer resource usage, control memory, I/O, and CPU resources
  • Combine data horizontally
  • Compress SAS data sets
  • Create user-defined functions and informats.
Delivery Method : Classroom Training / Live Web / Self Learning
Duration : 21 hours
Level : Intermediate
Languages : English
Enquire Now – Smartree