Introduction

Macro variables, known as symbolic variables, operate similarly to LIBNAME and table options. But, they have an advantage because they apply globally. That is, their value remains constant until explicitly changed.

This chapter presents reference information for SPD Server macro variables, including their purpose, default values, and when and how to use them. The variables are grouped by function or purpose of the default value. Changing the value can also change the purpose, making the variable fall into another group.

For example, the default setting for the macro variable SPDSSADD= is NO. The SPDSSADD= macro enhances performance during data appends. Setting SPDSSADD= to YES changes the way the variable functions. The macro setting SPDSADD=YES ensures compatibility with the Base SAS engine. The default setting improves performance. Changing the setting from the default improves Base SAS software compatibility.

To set a macro variable to YES submit the following statement:

%let MACROVAR=YES;

When you specify table option settings, precedence matters. If you specify a table option after you set the option in a macro variable statement, the table option setting takes precedence over the macro variable option setting. If you specify an option using a LIBNAME statement, and then later specify an option setting through a macro variable statement, the table option setting made in the macro variable takes precedence over the LIBNAME statement setting.

To view the default values for the SPD Server macro variables, use the SPDSMAC command associated with PROC SPDO. SAS displays the macro variables and their current settings. Understanding proper use of macro variables in SPD Server allows you to unleash the power of the software.