topic terminating macro references? in SAS Programming

terminating macro references?

Pavan_SAS — Fri, 08 Aug 2008 13:58:21 GMT

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?

Re: terminating macro references?

Olivier — Fri, 08 Aug 2008 14:02:36 GMT

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).

Re: terminating macro references?

Pavan_SAS — Fri, 08 Aug 2008 14:36:08 GMT

%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 !

Re: terminating macro references?

LinusH — Mon, 11 Aug 2008 09:22:32 GMT

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