deleting list of macro variables

[hdg]

Hello, I have a list of macro variables specified as below

proc sql noprint;

select count(distinct date) into :Num_Dates from &ds1;

select distinct date into : Date1-:Date%left(&Num_Dates)

from &ds1;

quit;

Is there a way to delete Date1 etc without having to list of all of them I normally use %symdel Thank you!

[jakarman]

Put your processing in a macro. All defined macro variables will  become in the scope local.

When the macro execution stops all local variables are deleted automatic. Nothing to bother about deleting them.

[hdg]

yes I am doing that but just wanted to know if there was a way for my own reference Thanks!

[data_null__]

There is a dictionary view and data step view of macro variables.  You can use that to create the list of variable names you want to delete.

[Quentin]

Here's an approach like _null_ suggested:

data _null_ ;

  set sashelp.vmacro ;

  where scope='GLOBAL' and offset=0 and name like "DATE%" ;

  call execute('%nrstr(%%)symdel '||trim(left(name))||';') ;

run ;