Hi everybody, I am trying to convert a character variable HAVE (format $6) that contains year and month which are written as yyyymm (e.g. 201801) into a date format (variable WANT), preferably expressed as 01JAN2018. In my Initial variable, the day is missing, so it should always be the first of a given month. How can I do this? I tried the following, but unfortunately it doesn't work: data test1; set test2; format WANT date9.; WANT = Input( HAVE, date9.); run; I would be very happy if somebody could help me. Thank you in advance! Kind regards, Gloria
... View more