Hope this would help you. I could do it in two steps... data d; input id= name=$20. dob=$10. sal= desig=$20.; cards; desig=Assistant manager id=100 name=krishna chandran sal=5000 dob=21/09/1989 id=101 dob=10/05/2010 desig=engineer sal=8000 name=hareesh Menon quit; data r; set d; dob_ = input(dob,ddmmyy10.); format dob_ ddmmyy10.; drop dob; rename dob_ = dob; run; Try this.. Lakshmi.
... View more
