I'm trying to run some proc sql within a macro and SAS won't recognise my macro variables. What am I doing wrong... %macro sixmonthroll(startdate,longstart,longend); rsubmit; proc sql; create table &startdate. as etc. etc. quit; endrsubmit; %sixmonthroll (jan16,jan_2016,jul_2016); When I run the code above I get the following error: 224 %sixmonthroll (jan16,jan_2016,jul_2016); NOTE: Remote submit to HOST commencing. 491 proc sql; 492 create table &startdate. as select - 22 200 WARNING: Apparent symbolic reference STARTDATE not resolved. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string.
... View more