|
Please help me. I am new to these syntax.
I have date stored in mmddyy format. I need to check its validity.
I am using Proc sql and an array.
I assign month and corresponding date using array
data _null_;
array mon(12) 31 28 31 30 31 30 31 31 30 31 30 31;
Here is proc sql
proc sql;
select tdate from work.project1
where
substr(tdate,3,2)> mon[%substr(tdate,1,2);
%put " Improper date" tdate ;
Thanks
| 
