LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (June 2010, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 10 Jun 2010 11:31:29 -0700
Reply-To:   SAS_learner <proccontents@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   SAS_learner <proccontents@GMAIL.COM>
Subject:   Using sysdate9. in where statement
Content-Type:   text/plain; charset=ISO-8859-1

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.


Back to: Top of message | Previous page | Main SAS-L page