Date:         Thu, 10 Jun 2010 11:34:55 -0700
Reply-To:     "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject:      Re: Using sysdate9. in where statement
Comments: To: SAS_learner <proccontents@GMAIL.COM>
In-Reply-To:  A<AANLkTilJTvIji3lUn0UBUOzWzU-lu71SRyIXjdozuTTK@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"

Hi SAS Learner,

Add a "d" modifier to turn the date string
into a SAS date number:

e.g.


Where Input(Lsdtc,yymmdd10.)
   le Input("&Sysdate9."d,ddmmyyyy10.)




Hope this is helpful.


Mark Terjeson
Investment Business Intelligence
Investment Management & Research
Russell Investments
253-439-2367


Russell
Global Leaders in Multi-Manager Investing





-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
SAS_learner
Sent: Thursday, June 10, 2010 11:31 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Using sysdate9. in where statement

Hello all ,

I am trying to see if there are any dates more than today and trying to
do
something like this and some how it is giving me warning

what is that I can do to get rid of this warning

thanks

21         Proc Sql Noprint ;
22           Create table lsr1 as
23         Select * , Sum (Lsstresn) as Lss_sum , Max(Lsspid) as Mx
24         From Lsr
25         Where Input(Lsdtc,yymmdd10.) le
Input("&Sysdate9.",ddmmyyyy10.)
26         Group By Usubjid ,  Visit , lsdtc
27         Order By Usubjid ,  Visit ,Visitnum , lsdtc ,lsspid ;
WARNING: INPUT function reported 'WARNING: Illegal first argument to
function' while processing WHERE
         clause.
NOTE: The query requires remerging summary statistics back with the
original
data.
NOTE: Table WORK.LSR1 created, with 0 rows and 10 columns.