Hello, Can you please walk me through how to convert this inconsistent text column to either time AM/PM or a 24hour time format? time_column: 9:28 AM 20:20 5:11 PM 7:30 11:12 PM 2:20 PM 23:20 I have tried and it's not working. data consist; set dataset; want=input(time_column, mdyampm23.); format want dateampm.; run; I really appreciate any help you can provide.
... View more