topic Re: how to convert character data to datetime in SAS Programming

how to convert character data to datetime

kevinjin — Mon, 12 Mar 2018 16:21:36 GMT

I'm trying to convert the character variable '201803120520' into datetime.

need help.

Thanks

andreas_lds — Mon, 12 Mar 2018 16:39:09 GMT

Check the informats starting with "any", maybe one of them can convert the char-value.

PaigeMiller — Mon, 12 Mar 2018 16:42:14 GMT

The ANYDTTME informat should work.

SuryaKiran — Mon, 12 Mar 2018 18:58:15 GMT

Hi,

You need to do some conversion Like:

data want;
Format Date_Val datetime26.;
Char='201803120520';
Date_Val=INPUT(CATS(SUBSTR(Char,1,8),"T",SUBSTR(Char,9),"00"),B8601DT15.);
run;