Logo EDU Trainings
advanced search
Do you have any questions?
+420 731 175 867 (Mo-Fr: 9A.M.-5P.M.)
EN
CZ SK
0 Basket
  • Technical courses
  • Subsidized courses
  • Soft skills
  • Voxy
  • Certifications
  • Blog
  • About us
  • Contact
  • Home
  • > Technical courses
  • > SAS® Macro Language 2: Advanced Techniques

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 200 EUR

1 452 EUR including VAT

Selection of dates
Send the course to a colleague
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
  • Course description
  • Target group
  • Course structure
  • Prerequisites

Course dates

Starting date: Upon request

Type: E-learning

Course duration: 21 hours

Language: en

Price without VAT: 1 380 EUR

Register

Starting date: Upon request

Type: Upon request

Course duration: 14 hours

Language: en

Price without VAT: 1 200 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
Upon request E-learning 21 hours en 1 380 EUR Register
Upon request Upon request 14 hours en 1 200 EUR Register
G Guaranteed course

Didn't find a suitable date?

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

Contact

SAS® Macro Language 2: Advanced Techniques

The date:
Takes place:
Form:
Language:
Price without VAT:

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

News directly to e-mail

Enter your e-mail and be the first to know about news, discounts and new course dates. We send the e-mail at most once a month.

Do you have any questions?
+420 731 175 867 (Mo-Fr: 9A.M.-5P.M.)
Facebook
Linkedin YouTube
  • Privacy Statement
  • Terms and Conditions
  • Information about course organization
© 2025 EDU Trainings
ComGate payment gateway MasterCard Logo Visa logo
Cookie Consent
To provide the best possible service, we use technologies such as cookies. Consent to these technologies will allow us to process data such as crawling behavior or unique IDs on this site. Disagreement or withdrawal of consent may adversely affect certain features and functions.
Functional Always active
Technical storage or access is essential for the legitimate purpose of enabling the use of a specific service expressly requested by a subscriber or user, or only for the purpose of transmitting a communication over an electronic communications network.
a:2:{s:4:"text";s:0:"";s:4:"show";b:1;}
a:2:{s:4:"text";s:0:"";s:4:"show";b:1;}
Statistics
Technical storage or access used exclusively for statistical purposes. a:2:{s:4:"text";s:0:"";s:4:"show";b:1;}
Marketing
Technical storage or access is required to create user profiles in order to advertise or track a user on a website or several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
Preferences
{title} {title} {title}