06-16-2014 11:18 AM
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!
input holidays dates9.;
select distinct holidays into : holiday_list
seperated by ', '
%Let today = $sysfunc(today());
%if &today. in (&holiday_list.) %then %do;
06-16-2014 11:56 AM
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.
06-16-2014 12:58 PM
The macro language is not well suited to the task of table look up. Consider this approach which does not involve macro language.
Need further help from the community? Please ask a new question.