如何判断一个宏变量是missing

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

我定义了一个宏变量， 我想判断它的值是不是missing
有没有类似于missing() 函数的宏函数呢？
我试了
%let help =XXXXX;

%if %sysfunc(missing(&help)) %then %do;

Error输出：
ERROR: The function MISSING referenced by %SYSFUNC, %QSYSFUNC, or %SYSCALL cannot be used within
       the MACRO function/call-routine interfaces.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric
       operand is required. The condition was: %sysfunc(missing(&help))

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：missing SSIN Miss ING Iss character function required cannot within

%let help =xxxx;

%macro test();
%if &help= %then %do;
        %put missing;
        %end;
%else %do;
        %put not missing;
        %end;
%mend ;

%test;

可以用

It works well.

THank you~

greatvia 发表于 2012-4-17 10:27
It works well.

THank you~

SAS 宏在处理判断字符的时候确实有些麻烦，但先测试一下就好了

What do you mean the value of a macro variable is missing? A defined macro variable with <space>? or undefined macro variable?

I get a value and save it in a macro variable, so I need to make sure what value it contains.

%help = %sysfunc(getoption(SysIn));
By judging the value of %help is null or not I know if the program executed with interact mode or batch mode.