Help using Base SAS procedures

Proc SQL Question

Reply
Regular Contributor
Posts: 173

Proc SQL Question

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
Super Contributor
Posts: 291

Re: Proc SQL Question

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);
Regular Contributor
Posts: 173

Re: Proc SQL Question

Thank you Bill !
Ask a Question
Discussion stats
  • 2 replies
  • 113 views
  • 0 likes
  • 2 in conversation