Date:         Mon, 19 Jul 2004 15:18:53 -0700
Reply-To:     Patrick.F.O'Neill@KP.ORG
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Patrick F O'Neill <Patrick.F.O'Neill@KP.ORG>
Subject:      Re: Trying to compare todays date to the contents of a date field
              in            an oracle database.
Comments: To: DavidF@HOMEGAIN.COM
Content-Type: text/plain; charset="US-ASCII"

I think you can just compare a timestamp directly to SYSDATE in this SQL
passthrough.  The () after SYSDATE() in your original are not part of
Oracle syntax.

PROC SQL;
connect to oracle(user='megan' pass='mzdm2xt' path='reporting2');
create table agents as select *
FROM
USER_OWN.T_AGENT A1,
USER_OWN.T_USER A2,
USER_OWN.T_MEMBERSHIP A3
where
D_MEMBERSHIP_EXPIRE_TS < SYSDATE
AS....
;
quit;