topic Convert character variable to timestamp in New SAS User

Convert character variable to timestamp

GS2 — Fri, 27 Dec 2019 18:54:25 GMT

Using SAS 9.4

Is there a method to convert a character variable in $16 format ( ie. '6/10/2017 5:28') into a numeric timestamp with DATETIME16. format (ie. '03FEB17: 19:33:00')? Thank you

Re: Convert character variable to timestamp

novinosrin — Fri, 27 Dec 2019 19:04:19 GMT

Hi @GS2

Try the mdyampm informat

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003172027.htm


data want;
char_time='6/10/2017 5:28';
want_time=input(char_time,mdyampm15.);
format want_time datetime18.;
run;

Re: Convert character variable to timestamp

Kurt_Bremser — Fri, 27 Dec 2019 19:04:05 GMT

Convert the separate parts (use the scan() function) into a date and time, and use the dhms() function to combine them into a datetime (use the time value as the "seconds" argument).