The SAS Macro Language: Powerful as a Corvette!


I love the power of my Corvette and the power of the SAS macro language.  That is why, for the past 12 months, when not driving my Corvette, I put my heart and soul into the challenging task of updating our SAS Macro Language 2 course, soliciting input from my colleagues in the SAS Education and SAS Technical Support divisions and from my SAS macro language students.

The SAS Macro Language 2: Advanced Techniques course is now available.  Check out the course outline for complete details.

Some of the advanced techniques in the revised course include:

  • the latest SAS 9.3 features
  • the Stored Compiled and Autocall Macro Facilities
  • macro quoting functions
  • data-driven macro calls
  • hierarchical, menu-driven macro applications
  • table lookup techniques
  • macro windows
  • custom pull-down menus
  • the EXECUTE routine
  • the SET routine
  • the %SYSCALL statement
  • %WINDOW and %DISPLAY statements
  • SAS I/O functions

A previous SAS Macro Language 2 student recently asked me if he should take the course again.  My answer was, “yes.”  The updated course, like my Corvette, is all about power!  The course follows a step-by-step incremental approach using more real-world business examples and exercises, and features new material, including several new advanced applications that:

  • Search out all SAS programs in a directory and all subdirectories and automatically submit every program;
  • Create a series of pop-up windows that interactively gather and validate user-supplied parameter values; and
  • Validate that a particular user-selected variable exists in a particular user-selected dataset and that the variable is of a particular type.

I developed this course for graduates of our SAS Macro Language 1: Essentials course who have gone back to the office, used the macro language, and now want to learn additional, more advanced techniques.  To help you choose which SAS Macro course is best for you, take our brief and anonymous self-assessment quiz.

My goal was to develop an advanced macro course that would be as exciting, fun, and challenging as driving a Corvette, (well, almost) and, most important, relevant to the real world business problems that SAS programmers encounter every day.

I look forward to your feedback and seeing you in class.

Tags SAS macro

About Author

Jim Simon

Principal Technical Training Consultant

Jim Simon is a principal instructor and course developer for SAS Education. Jim has a bachelor's degree from UCLA and a master's degree from California State University at Northridge. Prior to joining the SAS Irvine office in 1988, Jim was an instructor at Ventura College and a SAS programmer at The Medstat Group in Santa Barbara. Jim's areas of specialization include the DATA step, application development, web enablement, and the SAS macro language. A native of Southern California, Jim enjoys anything in the warm California sun. On weekends, Jim loves jumping in his Corvette, turning up the stereo, and cruising Pacific Coast Highway, top down, South to Laguna Beach or North to his old home town, Santa Barbara.


  1. Pingback: Macro programmers: watch out for the Dead Man’s Curve! - The SAS Training Post

Leave A Reply

Back to Top