|
楼主

楼主 |
发表于 2011-4-22 13:24:45
|
只看该作者
宏变量赋值带有空格,逗号和引号怎么办?谢谢!
%macro deleteRow (week =, key =);
data X_&week;
set Y_&week;
where substr(columnName,1,2) in (&key);
run;
%mend;
%macro iteration();
%do weekly = &startWeek %to &endWeek;
%deleteRow (week = &weekly, key = &keyWords);
%end;
%mend;
%let startWeek = 10;
%let endWeek = 11;
%let keyWords = [b:rejsopl2]'PP', 'PM' 'PN'[/b:rejsopl2];
%iteration()
现在我遇到的问题是[b:rejsopl2]'PP', 'PM' 'PN'[/b:rejsopl2]无法赋值到key里面的,我想请问宏变量赋值带有空格,逗号和引号怎么办?谢谢! |
|