topic SAS Date and time in SAS Programming

SAS Date and time

zimcom — Fri, 27 Sep 2019 17:01:01 GMT

Hi all,

I have a variable of text data type with data value looks like 'username1 17/04/28 13:34:44'.

the text string is the username and followed by the date (YY/MM/DD) and time (24 hour format).

I want to convert this variable into a datetime field looks like '28APR2017:13:34:44' of data type "datetime20." which I will use later in the program to calculate the time interval.

Thanks

Re: SAS Date and time

novinosrin — Fri, 27 Sep 2019 17:23:07 GMT

HI @zimcom Will this do?


data test;
have='username1 17/04/28 13:34:44';
want=dhms(input(scan(have,2,' '),yymmdd8.),0,0,0) +
  input(scan(have,-1,' '),time10.);
format want datetime20.;
run;

Re: SAS Date and time

zimcom — Fri, 27 Sep 2019 17:43:50 GMT

@novinosrin Thank you so much!!