topic Re: Proc SQL Question in SAS Procedures

Proc SQL Question

KevinC_ — Wed, 09 Jul 2008 17:49:04 GMT

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

Re: Proc SQL Question

Bill — Wed, 09 Jul 2008 20:14:48 GMT

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);

Re: Proc SQL Question

KevinC_ — Wed, 09 Jul 2008 21:25:07 GMT

Thank you Bill !