I have the below code that seems not to work the error seems to the "FROM" in my macro EXTRACT (Year FROM <DATE>) see the error below 75 EXTRACT(MONTH FROM ADD_MONTHS(CURRENT_DATE,0))
----
22
202
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, ), *, **, +, ',', -,
'.', /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT,
IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.
ERROR 202-322: The option or parameter is not recognized and will be ignored This is the code rsubmit;
%macro monmac (month=,tablename=, year=);
proc sql;
create table homedir.Table2 as
(select
subproduct,
travel_year,
travel_month,
brx_anclry_rev_vlu
FROM Homedir.Anc_Flown_All
WHERE travel_year = &year.
AND travel_month = &month.);
quit;
%mend monmac;
endrsubmit;
rsubmit;
%monmac(tablename = Forecast1, month = EXTRACT(MONTH FROM ADD_MONTHS(CURRENT_DATE,0)),year = EXTRACT(YEAR FROM ADD_MONTHS(CURRENT_DATE,0)))
run;
endrsubmit;
... View more
