So I tried the following (if that's what you're intending) and got the error below from the PROC SQL in statement. I tried it both ways to be sure. Thanks for the SUMPUTX suggestion. I'll make that change to modernize this old code.
data setup;
attrib
run_date length=8 format = mmddyy10.;
run_date = today();
day_of_week = weekday(run_date);
call symput("run_date",run_date);
call symput('day_of_week',day_of_week);
run;
%macro set_conditions;
%let location = 'LOCA1';
%if &week_day. = 2 %then %let location = ('LOCA1', 'LOCA2', 'LOCA3');
%if &week_day. = 5 %then %let location = ('LOCA1', 'LOCA4', 'LOCA5', 'LOCA6');
%mend;
%set_conditions;
Attempt 1:
52 and location_code in (location); ________ 22 202 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, (, -, SELECT.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
Attempt 2:
52 and location_code in (&location.); _ 22 76 WARNING: Apparent symbolic reference LOCATION not resolved. ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, (, -, SELECT.
ERROR 76-322: Syntax error, statement will be ignored.
... View more