Hi, I've assigned two values using %let and wish to use them to select the column 201809 from my table rather than create the value '201809' in my proc sql statement. Here's the code i have so far:
%let billyr = 2018;
%let billmth = 09;
proc sql;
create table test as select prod_cd, &billyr.&billmth. from sometable;
quit;
Any help would be greatly appreciated.
Thanks in advance,
Jeff!