Global and Local Symbol Tables 1 macro simp

Global and Local Symbol Tables 1

%macro simp proc sql; select count(*) into : numobs from fram. frex 4 ; quit; %mend; %simp %put &numobs;

%macro simp; %global numobs; proc sql; select count(*) into : numobs from fram. frex 4 ; quit; %mend; %simp %put &numobs;

The difference between global and local symbol tables. 4

The Global Symbol Table (Review) The global symbol table is Created during SAS initialization Initialized with automatic macro variables Deleted at the end of the session. 5

The %GLOBAL Statement %GLOBAL macro-variable 1 macro-variable 2. . . ; The %GLOBAL statement adds one or more macro variables to the global symbol table with null values. It has no effect on variables already in the global table. It can be used anywhere in a SAS program. 6

The Local Symbol Table Local macro variables can be created within a macro definition: %LET statement DATA step SYMPUTX routine PROC SQL SELECT statement INTO clause %LOCAL statement 7

The Local Symbol Table A local symbol table is Created when a macro with a parameter list is called or a local macro variable is created during macro execution Deleted when the macro finishes execution. Macros that do not create local variables do not have a local table. 8

The %LOCAL Statement %LOCAL macro-variable 1 macro-variable 2. . . ; The %LOCAL statement adds one or more macro variables to the local symbol table with null values. It has no effect on variables already in the local table. It can appear only inside a macro definition. 9

Rules for Creating and Updating Variables When the macro processor receives a request to create or update a macro variable during macro execution, the macro processor follows these rules: %let macvar=value; Does MACVAR already exist in the local table? No Does MACVAR already exist in the global table? No Create MACVAR in the local table. Yes Update MACVAR in the global table. 10

Rules for Resolving Variables To resolve a macro variable reference during macro execution, the macro processor follows these rules: &macvar Does MACVAR exist in the local table? Yes Retrieve from local table. No Does MACVAR exist in Yes Retrieve from global the global table? table. No Return tokens to word scanner. Issue a warning to SAS log: Apparent symbolic reference MACVAR not resolved. 11

The SYMPUTX Routine The optional scope argument of the SYMPUTX routine specifies where to store the macro variable: CALL SYMPUTX(macro-variable, text <, scope>); G specifies the global symbol table. L specifies the current macro's local symbol table. If no local symbol table exists for the current macro, a local symbol table is created. 12

The %LOCAL Statement Declare the index variable of a macro loop as a local variable to prevent accidental contamination of a like-named macro variable in the global table or another local table. %macro putloop; %local i; %do i=1 %to &numrows; %put Country&i is &&country&i; %end; %mend putloop; 13