Macro variables operate similarly to LIBNAME options and table options. But they have
an advantage because they apply globally. That is, their value remains constant until
explicitly changed. These variables can be used by the
SPD Server SAS client to service the behavior of the client and server.
To set a
macro variable to YES, submit the following statement:
%let macro-variable-name=YES;
CAUTION:
Assignments
for macro variables with character input (for example, YES | NO |
BINARY arguments) must be entered in uppercase (capitalized).
After you have set the value of a macro variable, you can verify its value by submitting
a PUT statement:
%put &=macro-variable-name;
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 server macro variables, use the PROC SPDO SPDSMACS
statement.
See SPDSMAC Statement in SAS Scalable Performance Data Server: Administrator’s Guide.