SAS V9.1.3 - 组合 %INC 和 CALL EXECUTE 时出错

Question

我遇到一些 SAS v9.1.3 代码的解析错误。

这是我想存储在 .txt 文件（称为 Problem2.txt）中的一些代码，并用 %INC 将其带入 SAS

%macro email020;                  
   %if &email = 1 %then %do;       
     %put THIS RESOLVED AT 1;      
   %end;                           
   %else %if &email = 2 %then %do; 
     %put THIS RESOVLED AT 2;      
   %end;                           
   %put _user_;                    
%mend email020;                   

%email020; 

然后这是主要代码：

filename problem2 'C:\Documents and Settings\Mark\My Documents\problem2.txt';

%macro report1;                            
  %let email = 1;
  %inc problem2;
%mend report1;                             

%macro report2 (inc);                            
  %let email = 2;                          
  %inc problem2;
%mend report2;                             

data test;                                 
  run = 'YES';                             
run;                                       

data _null_;                               
  set test; 
  call execute("%report1");  
  call execute("%report2");  
run;

日志显示：

NOTE: CALL EXECUTE generated line.
1   +  %inc problem2;
MLOGIC(EMAIL020):  Beginning execution.

WARNING: Apparent symbolic reference EMAIL not resolved.

ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &email = 1

ERROR: The macro EMAIL020 will stop executing.

MLOGIC(EMAIL020):  Ending execution.

所以问题是为什么 CALL EXECUTE 生成 %inc Problem2而不是 %report1，导致 SAS 错过分配，我该怎么办？

Answer 1

这似乎是一个宏变量范围问题。尝试：

%macro report1;   
  %global email; 
  %let email = 1;
  %inc problem2;
%mend report1;                             

%macro report2;            
%global email; 
  %let email = 2;                          
  %inc problem2;
%mend report2;                             

但是，我认为将 email 作为参数传递给 %email020 而不是使用全局宏变量会更好。另外，我会避免使用嵌套的宏定义。

要获取有关宏变量范围的更多数据，您可以在宏执行期间查询dictionary.macros视图。您可以使用以下命令获取dictionary.macros的描述

proc sql;
    describe table dictionary.macros;
quit;

Answer 2

%include 不是宏调用，而是一种编译器指令，用于包含来自外部文件的代码。当宏%report1编译时，没有宏变量email（因为该宏之前从未运行过），因此引用保持原样，&电子邮件。然后隐式 %eval() 看到 &email = 1 并抱怨，因为它看起来像是您正在比较文本(&email)针对数字 (1)。

如果可能的话，应避免引入%global。我会完全取消 %include 。简单得多，下面是。 :-)

%macro doSomething(email=);                  
  %if &email = [email protected] %then %do;       
    %put THIS RESOLVED AT 1;      
  %end; %else %if &email = [email protected] %then %do; 
    %put THIS RESOVLED AT 2;      
  %end;                           
  %put _user_;                    
%mend doSomething;                   


data emails;
  email="[email protected]"; output;
  email="[email protected]"; output;
run;

data _null_;
  set emails;
  call execute(catx(email, '%doSomething(email=', ')'));
run;

/* on log
THIS RESOLVED AT 1
DOSOMETHING EMAIL [email protected]
THIS RESOVLED AT 2
DOSOMETHING EMAIL [email protected]
*/