Chapter 4: Macro Programming with PROC SQL
PROC SQL supports the use of the SAS macro language. The focus of this chapter is less on the introduction to programming SAS macros, but rather on their application. This chapter presents numerous examples of SAS macros in application-oriented sections, which will extend the possibilities of working with PROC SQL, simplify it through automation, and accelerate it.
Technically speaking, macros are the automation of recurring processes within applications. Applied to SAS, they are the automated processing of the same application for many different variables, the efficient processing of different applications for the same variable, or a combination of both.
Because macros are based on SAS syntax, including ...
Get Advanced SQL with SAS now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.