topic Re: Delete all macro variables in SAS Enterprise Guide

Delete all macro variables

madara155 — Tue, 05 Jul 2022 00:21:03 GMT

I am trying to delete all the macro variables in a program and can't seem to find a method.

Saw that some people have suggested to use %SYMDEL but I don't know how to delete all the macro variables using it.

Can someone please help me?

Thanks

Re: Delete all macro variables

AlanC — Tue, 05 Jul 2022 01:06:39 GMT

Use the following options at the top of the program:

options mfile mprint obs=0 noerrorbyabend errors=0 source source2 nonotes;

filename mprint 'c:\temp\SasCode.txt’;

When you run your program, a new copy of it will be in the SasCode.txt file with all macros resolved.

Re: Delete all macro variables

Astounding — Tue, 05 Jul 2022 04:17:42 GMT

First, you have to realize that what you requested is not possible. You can only delete GLOBAL macro variables, You cannot delete LOCAL macro variables, and you cannot delete AUTOMATIC macro variables that are supplied by the software. So if deleting GLOBAL macro variables will satisfy what you need to do, here is a link that shows you how:

https://www.lexjansen.com/nesug/nesug06/po/po06.pdf

The specific example you requested begins at the bottom of page 3.

Re: Delete all macro variables

madara155 — Tue, 05 Jul 2022 05:14:08 GMT

Thanks.

I only wanted to delete the global macro variables I defined.

Regards.

Re: Delete all macro variables

Ksharp — Tue, 05 Jul 2022 12:06:12 GMT

Use this code to get all the macro variables .and %symdel them all.

proc sql;
create table x as
select * from dictionary.macros;
quit;