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

Hi Helannivas, Name    DOJ Ram     13/12/1988 Kumar   21/05/1989 Ishant    110488 In your input dataset Name and Doj both the variables are character please correct me if my understanding is wrong. ... View more

Hi MarkWik, The following code will resolve your problem. data table_b; set table_a; NAME_CONVENE_INDEX= substr(NAME_CONVENE,anydigit(NAME_CONVENE,1),1); NAME= trim(left(substr(NAME_CONVENE,anydigit(NAME_CONVENE,1)+1,length(NAME_CONVENE)-anydigit(NAME_CONVENE,1)))); run; Please give your feedback. Thank you. Gaurang Patel ... View more

I have never done it but you can use Row_no = _n_; ... View more