in function in SAS macro

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

In function is in SAS macro language since SAS 9.2 was launched.

options minoperator nomlogic;
%macro test(value)/mindelimiter=',';

%if &value in 1,2,3,4,5,6 %then
  %put >>>>Value found within list.;
%else %put >>>>Value not in list.;

%mend;
%test(3)
%test(7)

But one has to specify minoperator in option and mindelimiter=',' in a macro and it is hard to remember.

Now one can use data step 'in' function to have the same function and easy to remember.

%macro test2(value);

%if %sysfunc(in(&value, 1,2,3,4,5,6)) = 1 %then
  %put >>>>>Value found within list.;
%else %put >>>>>Value not in list.;

%mend;

%test2(3)
%test2(7)

扫码加我 拉你入群

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

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

分享0 收藏1 回帖

关键词：function Macro acr CRO CTI function

我觉得在需要in计算时options minoperato，计算一完成马上关掉options nominoperato，这样才不会影响其他地方出现的In和#

I used to think function IN are limited in data step.
And I think : %if %sysfunc(indexw("1 2 3 4 5 6","&value")) is also usefully.
But we don't have %indexw to use...