[PDF] sas macro array

How do I create a macro array in SAS?

SUMMARY Although the SAS macro language does not directly support the concept of an array, there are several ways to mimic a macro array. Two of the more common methods are to create lists of values. The elements in these lists can be stored in individual macro variables or as a list of values in a single macro variable.

What is a macro array?

A macro array is a list of macro variables that share the same prefix and a numeric suffix, for example, AA1, AA2, AA3, etc., plus an additional macro variable with a suffix of "N" that contains the length of the array. Two macros, %ARRAY and %DO_OVER, make it simple to create and use macro arrays.

What is a macro variable array in Proc SQL?

PROC SQL has an operator, INTO, that puts the resulting values from a query into one or more macro variables. Using the INTO operator creates a macro variable array. macro variable array is where there are macro variables that are similarly named, such as Var1, Var2, Var3, and so on. These can be processed as shown in a later example. Output 3.

What are the delimiters of array elements in SAS?

Array elements in the SAS software data step array statement are assumed to be delimited by spaces. When array- element values are provided to this routine as a list, the macro %scan function is used to pick out each value. The delimiters of the macro function %scan are the set of non-alpha-numeric characters.