SAS宏变量与特殊字符调用出错

请问宏变量&i怎么调用才正确？

1. %macro m;
   
2. %do i=1 %to 2;
   
3. proc tabulate data=z2;
   
4. class bc001 rgender da057_&i_;
   
5. table bc001*rgender,da057_&i_*(n pctn<da057_&i_>);
   
6. run;
   
7. %end;
   
8. %mend m;
   
9. %m;

复制代码

SAS日志如下：

just add . after i as the following code

%macro m;
%do i=1 %to 2;
proc tabulate data=z2;
class bc001 rgender da057_&i._;
table bc001*rgender,da057_&i._*(n pctn<da057_&i._>);
run;
%end;
%mend m;

补充：变量系列为da057_1_ da057_2_ da057_3_ da057_4_...想将其变为da057_i_的循环变量，请问宏语句中怎样写&i呢？

复制代码

如果确定变量相似但是不规律 也可用where name like 'da057%'

1. data a;
   
2. input bc001 $ rgender$ da057_1_ da057_2_ da057_ppp_;
   
3. cards;
   
4. a  x 1 2 9
   
5. a  x 3 4 7
   
6. b  y 8 5 6
   
7. ;
   
8. run;
   
9. proc contents data=a out=b noprint ;run;
   
10. %macro test;
    
11. proc sql noprint;
    
12. select count(name) into:count from b where name ne 'bc001' and 'rgender';
    
13. select name into:var1-:var%left(&count) from b where name ne 'bc001' and 'rgender';
    
14. quit;
    
15. %do i=1 %to &count.;
    
16. proc tabulate data=a;
    
17. class bc001 rgender &&var&i.;
    
18. table bc001*rgender,&&var&i.*(n pctn<&&var&i.>);
    
19. run;
    
20. %end;
    
21. %mend;
    
22. %test;

复制代码

jl60156 发表于 2015-1-22 17:26
just add . after i as the following code

%macro m;

谢谢！

sushe1527 发表于 2015-1-22 21:32
如果确定变量相似但是不规律 也可用where name like 'da057%'

谢谢！但是jl60156更切我的问题