topic Re: How to check existence of a macro variable . in SAS Procedures

How to check existence of a macro variable .

Mike_Davis — Fri, 27 Jul 2012 14:40:02 GMT

Hello everyone,

Sometime I don't know whether there was a macro variable in the SAS environment and I want to delete it .It will show me a warning message if the macro variable not exist when I trying to delete it.

%let bbb=1;

%SYMDEL aaa bbb; /*try to delete aaa and bbb,but aaa is not exist*/

"WARNING: Attempt to delete macro variable aaa failed. Variable not found."

My question is ,To avoid the warning message.How to check whether a macro variable exist before delete it?

Thanks

Mike

Re: How to check existence of a macro variable .

Haikuo — Fri, 27 Jul 2012 14:46:52 GMT

%let bbb=1;

%put %symexist(bbb);

%put %symexist(aaa);

Haikuo

Re: How to check existence of a macro variable .

Amir — Fri, 27 Jul 2012 14:55:30 GMT

Have you tried the %symexist macro function?

Regards,

Amir.

Re: How to check existence of a macro variable .

art297 — Fri, 27 Jul 2012 15:15:15 GMT

You could just add the /NOWARN option.

Re: How to check existence of a macro variable .

Astounding — Fri, 27 Jul 2012 19:56:06 GMT

Presumably, you must be asking about open code. Otherwise if you were talking about inside a macro, you could just use %SYMEXIST, as suggested by others:

%if %SYMEXIST(aaa) %then %SYMDEL(aaa);

Since %IF is not permitted in open code, here's a way around that:

data _null_;

set sashelp.vmacro;

where upcase(name)='AAA';

call execute('%symdel(aaa);');

run;

I'm not sure if I have the syntax exactly right here, but the approach should work easily enough. If you have a series of macro variables to delete, you would need to replace the WHERE statement:

if upcase(name) = 'AAA' then call execute('%symdel(aaa);');

else if upcase(name)='BBB' then call execute('%symdel(bbb);');

If you need to apply this to a long series of macro variable names, you might as well write a macro and stick with %symexist / %symdel.

Good luck.

Re: How to check existence of a macro variable .

art297 — Fri, 27 Jul 2012 21:22:10 GMT

In case my previous message wasn't sufficiently clear, I think the following does exactly what you want:

%let bbb=1;

%SYMDEL aaa bbb /NOWARN;

Re: How to check existence of a macro variable .

Astounding — Sat, 28 Jul 2012 03:04:10 GMT

Art,

It doesn't get any better than that. Good solution.