|
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.
|