topic Re: How to delete a Macro in a session? ( not macro variable) in SAS Programming

How to delete a Macro in a session? ( not macro variable)

suraestar — Wed, 29 Oct 2014 10:08:46 GMT

macrHi there,

Is there any statement or method to delete a macro in a session? as like we use SYMDEL for deleting a macro variable.

for instance,

%macro test:

----

-----

%mend test;

Now I would like to kill the test macro from the session.

Many Thanks

Surendar.

Re: How to delete a Macro in a session? ( not macro variable)

mohamed_zaki — Wed, 29 Oct 2014 10:13:00 GMT

Check this old thread

you can use Proc Catalog

Example:

proc catalog catalog=work;

delete test / et=macro;

quit;

Re: How to delete a Macro in a session? ( not macro variable)

Loko — Wed, 29 Oct 2014 10:41:29 GMT

Hello,

%macro a;
%put y;
%mend a;

proc catalog catalog=work.sasmacr et=macro;
delete a;
run;

Re: How to delete a Macro in a session? ( not macro variable)

KDEdmiston — Sat, 01 Aug 2020 15:40:27 GMT

proc catalog catalog = sasmacr;
delete test /et = macro;
run;
quit;

Re: How to delete a Macro in a session? ( not macro variable)

Tom — Sat, 01 Aug 2020 16:19:38 GMT

Not sure why this 6 year old thread has been re-activated, but there is now the %SYSMACDELETE macro statement for deleting compiled macros.

Here is a link to a macro that will make it easier to use that statement to delete multiple macros, including preventing you from trying to delete a macro you are currently running.

https://github.com/sasutils/macros/blob/master/macdelete.sas