SAS中文论坛

标题: 宏变量赋值带有空格，逗号和引号怎么办？谢谢！ [打印本页]

作者: shiyiming 时间: 2011-4-22 13:24
标题: 宏变量赋值带有空格，逗号和引号怎么办？谢谢！
%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里面的，我想请问宏变量赋值带有空格，逗号和引号怎么办？谢谢！

作者: Qiong 时间: 2011-4-22 13:33
标题: Re: 宏变量赋值带有空格，逗号和引号怎么办？谢谢！
%let keyWords =%str('PP', 'PM' 'PN');

欢迎光临 SAS中文论坛 (http://mysas.net/forum/)