You can't change a variable type in place. But you can create a new variable, but you have to assign a day/month to the year as well. if substr(CMSTDAT_P,1,1)='U' then CMSTDAT_DATE = mdy(1,1, input(substr(CMSTDAT_P,8,4),4.)); else CMSTDAT_DATE=input(cmstdat, date9.); You might need to play around with that a bit as I'm not 100% sure what your data looks like. You may be better off posting a new question with what your data looks like and what you want.
... View more