宏里面的in操作符

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

1. %macro sample_select(month);
   
2. %if %sysfunc(mod(&month.,100)) in (1 3 5 7 8 10 12) %then %let end=31;
   
3. %if %sysfunc(mod(&month.,100)) in (4 6 9 11) %then %let end=30;
   
4. %if %sysfunc(mod(&month.,100))=2 %then %let end=28;
   
5. %put &end.;
   
6. %mend;
   
7. %sample_select(201503);

复制代码

宏的%if语句中使用in操作符会报“需要的操作符在以下表达式中没有找到”错误，请问如何修改？谢谢

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：操作符 sysfunc Select Sample month 表达式 如何

加上这句话：options minoperator mindelimiter=',';

以下是官网的解释：
An IN operator is available for the macro language beginning in SAS® 9.2. The IN operator can be used in the %IF statement only when the MINOPERATOR option is set in the %MACRO statement or as a SAS® system option.

/* Prior to SAS 9.2, the following syntax was used */
%macro test(value);
   %if &value=1 or &value=2 or &value=3 or &value=4 or
       &value=5 or &value=6 %then %put Value found within list.;
   %else %put Value not in list.;
%mend;

%test(3)

是不是%in呀

johyw 发表于 2016-7-9 06:01
加上这句话：options minoperator mindelimiter=',';

以下是官网的解释：

非常感谢，我也搜了下，最全的解释如下：


This useful addition came in SAS 9.2 and I am amazed that it isn’t enabled by default. To do that you need to set the MINOPERATOR option unless someone has done it for you in the SAS AUTOEXEC or another configuration program. Thus, the safety first approach is have code like the following:

options minoperator;

%macro inop(x);

%if &x in (a b c) %then %do;
%put Value is included;
%end;
%else %do;
%put Value not included;
%end;

%mend inop;

%inop(a);

Also, the default delimiter is the space so if you need to change that, then the MINDELIMTER option needs setting. Adjusting the above code so that the delimiter now is the comma character gives us the following:

options minoperator mindelimiter=”,”;

%macro inop(x);

%if &x in (a,b,c) %then %do;
%put Value is included;
%end;
%else %do;
%put Value not included;
%end;

%mend inop;

%inop(a);

Without any of the above, the only approach is  to have the following and that is what we had to do for SAS versions prior to 9.2:

%macro inop(x);

%if &x=a or &x=b or &x=c %then %do;
%put Value is included;
%end;
%else %do;
%put Value not included;
%end;

%mend inop;

%inop(a);

It may be clunky but it does work and remains a fallback in newer versions of SAS. Saying that, having the IN operator available makes writing SAS Macro code that little bit swisher so it’s a good thing to know.

johyw 发表于 2016-7-9 06:01
加上这句话：options minoperator mindelimiter=',';

以下是官网的解释：

想探讨一下遇到这类问题的解决办法，怎么能搜到这些相关资料呢
我用中文搜索啥也没有，看了你的解释后，用英文搜options minoperator mindelimiter，结果答案全出来了。
看样子SAS问题还是得用英文来搜索啊

johyw 发表于 2016-7-9 06:01
加上这句话：options minoperator mindelimiter=',';

以下是官网的解释：

想探讨一下遇到这类问题的解决办法，怎么能搜到这些相关资料呢
我用中文搜索啥也没有，看了你的解释后，用英文搜options minoperator mindelimiter，结果答案全出来了。
看样子SAS问题还是得用英文来搜索啊

看起来google在这方便是比baidu好一点？