topic Re: SAS Macro Question in SAS Programming

SAS Macro Question

KevinC_ — Mon, 16 Jun 2014 15:18:22 GMT

Hello Everyone,

I have a macro called Copy_Datasets. It reads an input file and appends the word "holiday" to the end of the file name if today's date is one of the holidays defined in the holiday_file. When I run the macro i get an error "Required operator not found in expression: &today. in (&Holiday_List.)" from the macro. Does anyone have any suggestions as to how I can fix this issue? I have listed my code below. Thank you!

Data holiday_file;

input holidays dates9.;

datalines;

16jun2014

04jul2014

01sep2014

;

run;

proc sql;

select distinct holidays into : holiday_list

seperated by ', '

from holiday_file;

quit;

%Let today = $sysfunc(today());

%macro Copy_Datasets(infile);

%if &today. in (&holiday_list.) %then %do;

data &infile._holiday;

set &infile.;

run;

%end;

%mend;

%Copy_Datasets(cust_file)

Re: SAS Macro Question

Reeza — Mon, 16 Jun 2014 15:31:17 GMT

%Let today = $sysfunc(today());

% instead of $ sign?

As well as dateS9 instead of date9 in the first input program.

Re: SAS Macro Question

JasonAllen — Mon, 16 Jun 2014 15:34:03 GMT

Hello KevinC,

Is system option "minoperator" set? See: SAS(R) 9.4 Macro Language: Reference

Re: SAS Macro Question

Astounding — Mon, 16 Jun 2014 15:56:27 GMT

In addition to the other comments you already received, I believe that the macro version of the IN operator does not use parentheses around the list of values.

Re: SAS Macro Question

KevinC_ — Mon, 16 Jun 2014 16:11:07 GMT

Thank you all for your reply, I really appreciate it!

Jason,

I added the options minoperator and it resolved the issue.

Thank you everyone again

Re: SAS Macro Question

data_null__ — Mon, 16 Jun 2014 16:58:44 GMT

The macro language is not well suited to the task of table look up. Consider this approach which does not involve macro language.

data base; *example base data to recieve the word holiday;
   set sashelp.class;
   run; 

Data holiday_file(index=(holidays));
input holidays date9.; 
datalines; 
16jun2014
04jul2014
01sep2014
; 
run; 

data base;
   if 0 then modify base;
   holidays=today();
   set holiday_file key=holidays;
   if _iorc_ ne 0 then stop; 
   Name='Holiday'; 
   output; 
   stop; 
   run; 
Proc print data=base;
   run; 