Hi stat@sas, Your suggestion worked very well and many thanks. For my learning, I would like to ask 2 questions from your code (permitting your time). data t; input open_date :anydtdte. age; new_date=input(put(open_date,YYMMN.),best.); cards; 30Sep2011 7 01Dec2014 2 ; run; 1. 1. In yellow place above, you have used “anydtdte.” as the informat of variable “open_date”. But we know by looking at the data set, this informat is date9. So, is there any special reason to use :anydtdte. instead of date9. and what “anydtdte.” is really doing? 2. 2. when you convert the character var to numeric, you have used green color “numeric informat” called "best.". But we know that informat is 6. because our convered character var always have 6 characters such as 201109, 201412. Is there any special reason to use best. instead of 6. Thanks Mirisa
... View more