Dear Tom, Is it possible to achieve same result without tranwrd (without removing 'UM' or other letters)? I need to have a dynamic code. I started to solve on this way , but it didn't work yet. Thanks in advance. data task_1; input date: $9. ; day=substr(date,1,2); month=substr(date,3,3); year=substr(date,6,4); if (day) then day1=day; if (year) then year1=year; month1=put(month,3.); if (month) then month1=month; newdate=cats(year1,month1,day1); datalines; 21APR2004 18JUL1981 umfeb2007 UMUMK1968 umumkumk ;
... View more