terminating macro references?

[Pavan_SAS]

hi all,

how i can terminate all userdefined global and local macro variable references in a sas session?

is there any special keyword or macro function to terminate?

ex: %let a=pavan;

like this so many macro variables created.


after all these creations, i want to terminate all mavro variable values, so that i can use same names for other values.

how?

[Olivier]

You can use the %SYMDEL macro-instruction. And you can get the user-defined macro-variable names either with dictionary.macros (in a SQL query) or with sashelp.vmacro (in a Data step).

[Pavan_SAS]

%let a=pavan;

by using %symdel a; i am deleting that macro variable. its good.

how i can delete all userdefied macro vars?

can i use, %symdel _all_; to delete all?


help me !

[LinusH]

As Olivier pointed out, you can use dictionary.macros/sashelp.vmacro. Try this out:

%let a=Linus;

proc sql noprint;
select name into: userMac separated by ' '
from dictionary.macros
where scope = 'GLOBAL';
quit;

%symdel &userMac UserMac;

proc sql;
select * from dictionary.macros;
quit;

Beware that this code alse deletes macro variables such as SQLMSG etc.

Regards,
Linus