topic Re: compare a macro variable with macro variable list in SAS Programming

compare a macro variable with macro variable list

shubham13 — Mon, 15 May 2017 04:33:26 GMT

%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 ??

Re: compare a macro variable with macro variable list

Saurabh13 — Mon, 15 May 2017 04:48:23 GMT

Use %do%while loop witth %scan function.

It's very easy.

Re: compare a macro variable with macro variable list

shubham13 — Mon, 15 May 2017 04:51:24 GMT

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 ?

Re: compare a macro variable with macro variable list

Shmuel — Mon, 15 May 2017 10:08:12 GMT

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.

Re: compare a macro variable with macro variable list

Reeza — Mon, 15 May 2017 05:29:49 GMT

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

Re: compare a macro variable with macro variable list

user24feb — Mon, 15 May 2017 05:41:17 GMT

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

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

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

Re: compare a macro variable with macro variable list

Kurt_Bremser — Mon, 15 May 2017 06:37:16 GMT

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)

Re: compare a macro variable with macro variable list

s_lassen — Mon, 15 May 2017 11:52:20 GMT

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

Re: compare a macro variable with macro variable list

PaigeMiller — Mon, 15 May 2017 12:04:31 GMT

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

Re: compare a macro variable with macro variable list

Ksharp — Mon, 15 May 2017 12:24:00 GMT

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;

Re: compare a macro variable with macro variable list

shubham13 — Mon, 15 May 2017 12:35:18 GMT

thank you sir, it worked !