I am using Proc SQL to retrieve Begin_Date greater then FY_Year. Begin_Date is in the table the Proc SQL is using. But the FY_Year is a calculated value in the SAS program. How can I reference the FY_Year in my query?
here is what i currently have:
CREATE TABLE C AS SELECT * FROM CONNECTION TO DB2 (
SELECT ENTITYID AS EID, BEGIN_DATE
WHERE BEGIN_DATE > FY_YEAR
FOR READ ONLY);
I am getting a error on the where. Whats the proper way to reference FY_YEAR?