[原创博文] 请问高手如何组合N个宏变量名，谢谢！ (还没解决啊） [推广有奖]

21楼

zfpg 发表于 2011-11-7 23:31:13

学习

22楼

bobguy 发表于 2011-12-5 00:33:41

Here is a solution. Assume you know the prefix of a list of macro variables.

proc sql noprint;
select name into : vlist separated by ' '
from dictionary.macros
where scope='GLOBAL' and (name like 'L%' or name like 'W%')
order by 1
;
quit;

%SYMDEL &vlist;

%put _all_;

***create some macro variables***;
data _null_;
  n=ceil(10*ranuni(-1));
  do i=1 to n;
call symputx(catt('L',i), i);
  end;
  n=ceil(10*ranuni(-1));
  do i=1 to n;
call symputx(catt('W',i), i);
  end;
run;

***make a variable w/ prefix into a list;
proc sql noprint;
select name into : vlistL separated by ' '
from dictionary.macros
where scope='GLOBAL' and name like 'L%'
order by 1
;
quit;

%put >>>>&vlistL<<<<;

***make a variable w/ prefix into a list;
proc sql noprint;
select name into : vlistW separated by ' '
from dictionary.macros
where scope='GLOBAL' and name like 'W%'
order by 1
;
quit;

%put >>>>&vlistL<<<< >>>>&vlistW<<<<;