Variable not found on file

[radha009]

i have table with data column Month with 12 month names

%put &month.;  /* displays September

/Trying to get row that month = September

data sh.week_sch1;
set sh.B_fruit;
where Month = &month.;
run;

Error 

ERROR: Variable September is not on file SH.B_Fruit

[novinosrin · Accepted solution]

Please try "&month"

data sh.week_sch1;
set sh.B_fruit;
where Month = "&month";
run;

[Kurt_Bremser]

Without the quotes, the word September looks to the data step compiler like a variable name:

data sh.week_sch1;
set sh.B_fruit;
where Month = September;
run;

[sustagens]

You still have to enclose the macro variable month in quotes so that it is processed as a literal string in the where condition.