Proc SQL Question

[KevinC_]

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:

PROC SQL;
CREATE TABLE C AS SELECT * FROM CONNECTION TO DB2 (
SELECT ENTITYID AS EID, BEGIN_DATE
FROM ADUADS01.ADVTB914
WHERE BEGIN_DATE > FY_YEAR
FOR READ ONLY);

I am getting a error on the where. Whats the proper way to reference FY_YEAR?

Thank you soo much for any input!!
Kevin

[Bill]

Kevin;

for Oracle passthru one can use a macro variable ...

%let FY_YEAR=2008

PROC SQL;
CREATE TABLE C AS SELECT * FROM CONNECTION TO DB2 (
SELECT ENTITYID AS EID, BEGIN_DATE
FROM ADUADS01.ADVTB914
WHERE BEGIN_DATE > &FY_YEAR
FOR READ ONLY);

[KevinC_]

Thank you Bill !