I am not sure how to write that in SAS code, I tried putting the where clause on the data(DST_EMP1) but it is giving me an error with the following code as below:
PROC SQL;
CREATE TABLE EMPC_VPA AS
SELECT T1.VPAA, T1.ST, T1.DATE_OF_APPROVAL, T1.DATE_OF_ONBOARD, T1.FIN_EMP_CODE,T1.Emp_Code, T1.target, T2.*
FROM DST_EMP1 T1 where DATE_OF_APPROVAL between intnx('month', today(), -1, 'B') and intnx('month', today(), -1, 'E')
left join DEC_TXN1 T2 on T1.VPAA =(T2.VPA);
QUIT;
Error as below:
PROC SQL;
77 CREATE TABLE EMPC_VPA AS
78 SELECT T1.VPAA, T1.ST, T1.DATE_OF_APPROVAL, T1.DATE_OF_ONBOARD, T1.FIN_EMP_CODE,T1.Emp_Code, T1.target, T2.*
79 FROM DST_EMP1 T1 where DATE_OF_APPROVAL between intnx('month', today(), -1, 'B') and intnx('month', today(), -1, 'E')
80 left join DEC_TXN1 T2 on T1.VPAA =(T2.VPA);
----
22
76
ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, AND, EXCEPT, GROUP, HAVING, INTERSECT, OR,
ORDER, OUTER, UNION, |, ||.
ERROR 76-322: Syntax error, statement will be ignored.
Kindly, help in correcting the syntax.
... View more
