Hi, I have character variables containing datetime stamps in the format of 0000-00-00-00.00.00.000000 (e.g. 2008-01-03-09.58.19.207772) I am currently able to extract the date part of these variables using the below code: data want; set have; char_date = substr(char_date_time,1,10); num_date = input(char_date,anydtdte11.); format num_date_time2 ddmmyy10.; run; I now want to complete the same exercise in this step to extract the time from these variables in to its own variable, but after trying a number of things I can't seem to get it to work. Hopefully someone can help. Thanks in advance.
... View more