date format conversion in yyyy-mm-dd hh: mm: ss

arpitagarwal512 — Sat, 25 Feb 2017 09:36:27 GMT

Hi Team,

i am unable to convert below date format:

"02/05/1992" to "1992-05-05 : 00:00:00"

source is in string format and output should be in numeric format.

Re: date format conversion in yyyy-mm-dd hh: mm: ss

jklaverstijn — Sat, 25 Feb 2017 10:29:01 GMT

You're looking at a simnple two-step process:

1) Convert the string to a date

2) Convert the date to a datetime

This can be done in a single line of code:

new_dt = dhms(input(date_str, ddmmyy10.), 0,0,0);

Now you have a datetime. But I do not know a predefined format for that so you may have to roll your own. Have a look at this how to do that.

EDIT: This would be how to do the custom format:

proc format;
  picture mydt other='%0Y-%0m-%0d : %0H:%0M:%0S' (datatype=datetime);
run;