Hi Helannivas, The following code will solve your problem if the data type of DOJ is Character in your input dataset. data out_d; set in_d; pos=findc(doj,'/',1); if pos = 0 then new_d = mdy(month(substr(doj,3,2)),day(substr(doj,1,2)),year(substr(doj,5,2))); else new_d = mdy(month(substr(doj,4,2)),day(substr(doj,1,2)),year(substr(doj,7,4))); format new_d ddmmyy8.; run; Please give your feedback. Thank you. Gaurang Patel
... View more