Convert Character variable / string YYYYMM in date

gloooria — Fri, 16 Mar 2018 10:49:58 GMT

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

Re: Convert Character variable / string YYYYMM in date

Kurt_Bremser — Fri, 16 Mar 2018 10:57:16 GMT

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

Re: Convert Character variable / string YYYYMM in date

gloooria — Fri, 16 Mar 2018 13:03:53 GMT

Thank you a lot, it worked out.

topic Convert Character variable / string YYYYMM in date in SAS Enterprise Guide

Convert Character variable / string YYYYMM in date

Re: Convert Character variable / string YYYYMM in date

Re: Convert Character variable / string YYYYMM in date