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
Please try "&month"
data sh.week_sch1;
set sh.B_fruit;
where Month = "&month";
run;
Please try "&month"
data sh.week_sch1;
set sh.B_fruit;
where Month = "&month";
run;
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;
You still have to enclose the macro variable month in quotes so that it is processed as a literal string in the where condition.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.