advanced search
Do you have any questions?
+420 731 175 867 (Mo-Fr: 9A.M.-5P.M.)
EN
0 Basket

SAS® Macro Language 2: Advanced Techniques

Course code: MC2

This course covers macro quoting functions, macro storage, and macro techniques for advanced data access, table lookup operations, advanced parameter validation, and macro windows.

1 080 EUR

1 307 EUR including VAT

Selection of dates
onas
Do you have a question?
+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

View soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: Upon request

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 1 080 EUR

Register

Starting
date		 Place
Type Course
duration		 Language Price without VAT
Upon request In-person/Virtual 2 days en/cz 1 080 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course description

Learn How To

  • Store and share macros with the autocall macro facility and stored compiled macros.
  • Protect special characters with macro quoting functions.
  • Automate data-driven macro calls.
  • Access data properties with SAS I/O functions.
  • Work with external directories and files in a macro program.
  • Resolve macro variables during DATA step execution to perform table lookup operations.
  • Create your own macro functions.
  • Integrate parameter validation in macro programs.
  • Build self-documenting macros.
  • Use the macro language with SAS Viya.

Target group

Experienced SAS macro programmers who want to learn advanced techniques

Course structure

Advanced Macro Concepts

  • Storing macros with the autocall facility.
  • Understanding macro program flow.

Protecting Special Characters

  • Protecting constant text during macro compilation.
  • Protecting resolved text during macro execution.

Accessing Data with the Macro Language

  • Automating macro calls.
  • Accessing data properties with SAS I/O functions.

Working with External Files

  • Working with directory contents in a macro program.
  • Working with external files in a macro program.
  • Working with Microsoft Excel files in a macro program.

Resolving Macro Variables during DATA Step Execution Validating Macro Parameters Additional Macro Topics

  • Building self-documenting macros.
  • Using the stored compiled macro facility.
  • How to use the macro language in SAS Viya.

Prerequisites

In order to be successful in this course, you should have completed the SAS Macro Language 1: Essentials course or have equivalent knowledge and experience. Specifically, you should be able to:;

  • Write macro programs that contain iterative processing and conditional processing.
  • Create local and global macro variables.
  • Create macro variables using the SYMPUTX routine.
  • Use indirect macro variable references.
  • Use the INTO clause in the SQL procedure’s SELECT statement.

Do you need advice or a tailor-made course?

onas

product support

+420 731 175 867

edu@edutrainings.cz

ComGate payment gateway MasterCard Logo Visa logo