compare a macro variable with macro variable list

[shubham13]

%let var1=12MAY2017;

proc sql ;
select H_date into:var2 seperated by ',' from Holiday_list ;
quit;

var2 will contain values from 01JAN2017 to 31DEC2017 (holiday list for 2017)

how to see if var1 contains values in var2 ??

[Saurabh13]

Use %do%while loop witth %scan function. 

It's very easy.

[shubham13]

I want to use this as 

if &va1 contains value in &var2 then do;

-----------------------

end;

else do;

------------------------------------

end;

can u tell me how can i compare in an if condition ?

[Shmuel]

Try next code:

data want;

  set have;

        retain holydays "&var2";  /* the list */

        if  index(holydays,"&var1") then do;

         ---- holyday action ----

       end;

      else do;

      ------

      end;

run;

I have edited the code to repair some typos.

[shubham13]

thank you sir, it worked !

[Reeza]

Using SYSFUNC will allow you to use the standard SAS FINDW or INDEXW functions. 

[user24feb]

Flag will be 0 if not in list, integer otherwise:

%Let Flag=%Index("&var2",&var1.);

.. and you have a typo in "separated".

[Kurt_Bremser]

Why use a macro variable list at all?

%let var1=12MAY2017;
 
%let flag = 0;

data _null_;
set Holiday_list;
if var2 = "&var1"d then call symput('flag','1');
run;

Assuming that var2 in Holiday_list is a SAS date variable (numeric with date format assigned)

[s_lassen · Accepted solution]

Shubham,

So far you got a lot of good hints, but not a complete solution.

It is quite simple, though:

%sysfunc(indexw(&var2,&var1)) will give you a positive number if &VAR1 is present as a word in &VAR2, otherwise you will get 0.

So you can use it in a macro like

%if %sysfunc(indexw(&var2,&var1)) %then...

Regards,

Søren

[PaigeMiller]

You can use the %inm macro to replicate the functionality of the SAS command IN as a macro

The macro is explained here, it's pretty simple

https://groups.google.com/forum/#!topic/comp.soft-sys.sas/fWcSDgg11tE

[Ksharp]

You want put it in Data Step or A Macro ?


%let var1=12MAY2017;
 
data holiday_list;
 do h_date='01jan2017'd to '01jun2017'd ; 
  output;
 end;
run;
proc sql noprint;
select put(H_date,date9.) into:var2 separated by ',' from Holiday_list ;
quit;

data x;
 set holiday_list;
 if findw(symget('var2'),"&var1") then put 'found'; 
  else put 'not found';
run;