Convert Character variable / string YYYYMM in date

[gloooria]

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

[Kurt_Bremser · Accepted solution]

data test1;
set test2;
format want date9.;
want = input(have !! "01", yymmdd8.);
run;

[gloooria]

Thank you a lot, it worked out.