topic Re: Variable not found on file in SAS Programming

Variable not found on file

radha009 — Tue, 01 Oct 2019 23:11:06 GMT

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 — Tue, 01 Oct 2019 23:22:06 GMT

Please try "&month"

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

Kurt_Bremser — Wed, 02 Oct 2019 05:25:37 GMT

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 — Wed, 02 Oct 2019 05:37:30 GMT

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