02-25-2017 04:36 AM
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.
02-25-2017 05:25 AM - edited 02-25-2017 05:29 AM
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;